Hi and welcome to the forum
1 thing to remember about working with time in excel, is that excel treats time as a fraction/decimal of 1. So 6am is actually 0.25, 12 noon is 0.5 etc. So if you are working with time that goes from 1 day to the next, you need to subtract the start time from 1.00 and then the end time (in simple terms)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Can you give me an example? Start at 23:42 on day one and end at 3:08 on day 2 . . . on my fingers its 3.5 hours, but I want Excel to tell me that.
To test for the today-tomorrow situation...
=IF(A1>B1,(1-A1)+B1,B1-A1)
So if you swap those times around, you would get 20:34 20 hours 34 minutes
Assume 23:42 is in A1 and 3:08 in B1 - put this formula in C1:
=B1-A1+(A1>B1)
Format the cell as time, and you should see 3:26 - not sure why you think it should be 3.5, but if you want to see the result in hours, then you can do this:
=(B1-A1+(A1>B1))*24
and format the cell as General or Number - you should see 3.43333.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks