Hi...
I am trying to find a sum, that will add a pre midnight time to a post midnight time to show the amount of hours. I.E. 22:00PM + 06:00AM should show 8 Hrs, but it doesn't, it shows 4 Hrs...
Can anyone help, please...
Snowmonster
Hi...
I am trying to find a sum, that will add a pre midnight time to a post midnight time to show the amount of hours. I.E. 22:00PM + 06:00AM should show 8 Hrs, but it doesn't, it shows 4 Hrs...
Can anyone help, please...
Snowmonster
Take a look at Chip Pearson's site
http://cpearson.com/excel/overtime.htm
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
If start time is in A2 and end time in B2 you can use this formula
=MOD(B2-A2,1)
format result cell as h:mm
An alternative
=B2+(A2>B2)-A2
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks