Home |
Search |
Today's Posts |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Time Calculations
Peo, tried what you suggested hwvr, still arriving with the same result of a
0 figu 10/01/2008 06:00 10/02/2008 06:00 00:00 Where the formula is =MOD(B1-A1;1) and the answer format is [hh]:mm. Can you sugguest anything that will make the result equal 24:00? Thanks in advance for your assistance. Best regards, -- Mark "Peo Sjoblom" wrote: For 24 hours and above you would need the date as well then use custom format [h]:mm -- Regards, Peo Sjoblom "Mark" wrote in message ... thanks for the info Roger, however i have arrived at another problem whe 6:00 AM - 6:00 AM = 00:00:00 Even if i put a date to it the result is the same. How can i get this to recognize or bring me back a result of 24 hrs? Thanks in advance for your assistance. Best regards, -- Mark "Roger Govier" wrote: Hi Mark It should be B1-A1, but in order to cope with times crossing the 24 hour barrier, use =MOD(B1-A1,1) -- Regards Roger Govier "Mark" wrote in message ... I have an instance where we are using excel to calculate work times however on some calculations an error appears. I am told that excel does not calcuate or recognize negative time differences. The formula that I am currently using is A1-B1. Is there any way to over come this? Time In Time Out Hours Worked 6:00 AM 6:30 PM #### 6:30 PM 6:00 AM 12:30 Thanks in advance for your help. -- Mark |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time difference calculations, daylight savings time, Excel | Excel Discussion (Misc queries) | |||
Overlapping time calculations and automatic time updates | Excel Worksheet Functions | |||
time calculations | Excel Worksheet Functions | |||
More than calculations in time | Excel Discussion (Misc queries) | |||
convert time imported as text to time format for calculations | Excel Worksheet Functions |