Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time
I am going from before midnight to well after midnight and need to have excel
calculate this time. It is giving me a negative answer sometimes and other times is gives me ######. I want to know if you can convert this so it just calculates that time or will i need to figure that out with out excels help. Its a lot of data so i prefer not to do this. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time
=MOD(B1-A1,1) will give difference in hours/minutes
A1=Start time B1=Finish time "tibbsu2" wrote: I am going from before midnight to well after midnight and need to have excel calculate this time. It is giving me a negative answer sometimes and other times is gives me ######. I want to know if you can convert this so it just calculates that time or will i need to figure that out with out excels help. Its a lot of data so i prefer not to do this. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Converting time
It would have helped to see your formula
Assume: A1 has start time B1 has end time (and this could be the next day) Use =(B1-A1)+(B1<A1) The last term adds 1 day (i.e. 24 hours) if the second time is next day Format the cell with hh:mm best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "tibbsu2" wrote in message ... I am going from before midnight to well after midnight and need to have excel calculate this time. It is giving me a negative answer sometimes and other times is gives me ######. I want to know if you can convert this so it just calculates that time or will i need to figure that out with out excels help. Its a lot of data so i prefer not to do this. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting time to a range of time | Excel Discussion (Misc queries) | |||
Converting time formats into actual time(minutes) | Excel Discussion (Misc queries) | |||
Converting Eastern time to Central time | Excel Discussion (Misc queries) | |||
Converting decimal time to standard time? | Excel Discussion (Misc queries) | |||
Can't stop time duration [hh]:mm:ss converting to time of day | Excel Discussion (Misc queries) |