-
Hi, Debauch!
I?m not clear about what you are trying to accomplish, but let me emphasize that when doing arithmetic with time on two different days, then you must account for the date change too. Also, when subtracting times, then often you need to use brackets in the cell format to enclose the hours value. Instead of using ?hh:mm:ss?, use ?[hh]:mm:ss?.
Look at this example:
In cell A1: 6/15/06 23:25
In cell A2: 6/16/06 00:01
Format cell A3 as [hh]:mm
then in A3 put the formula = A2 ? A1
The result in A3 should be 0:36:00
HTH
SId
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules