Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time formula
Anyone know if there is a function for subtracting the difference
between two times, though, using negative data such as 2:51 am - 9:08 pm. Yes, I could figure it out in my head but when one has to do hundreds of them, it's time consuming. Thank you |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time formula
Meanie wrote:
Anyone know if there is a function for subtracting the difference between two times, though, using negative data such as 2:51 am - 9:08 pm. Yes, I could figure it out in my head but when one has to do hundreds of them, it's time consuming. See this thread for dealing with midnight (watch the wordwrap): https://groups.google.com/forum/#! topic/microsoft.public.excel.worksheet.functions/aDkj8ab8iwY -- Don't worry, I'm sure your Mom thinks you're cool. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time formula returns night time by mistake | Excel Discussion (Misc queries) | |||
formula for converting military time to standard time, etc | Excel Discussion (Misc queries) | |||
convert from percentage of time to time using complex formula in . | Excel Worksheet Functions | |||
Formula to find Stop Time from Start Time and Total Minutes | Excel Worksheet Functions | |||
template or formula for start time -finish time -total hours ple | New Users to Excel |