Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Elapsed time when separate cells contain time and separate date
Have 2 pairs of cells representing two events -- a date and time for each
event stored as text with the date cell in form mm/dd/yyyy and the time cell in form hh:mm xM. Need to find the elapsed time between the two events in hours and minutes placed in separate cells. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Elapsed time when separate cells contain time and separate date
Suppose your cells are arranged like this:
date time A1 B1 A2 B2 Then enter in cell for hours =INT(MOD((A2+B2-A1-B1),1)/(1/24))+INT((A2+B2-A1-B1)/1)*24 for minutes =MOD(MOD((A2+B2-A1-B1),1),1/24)*24*60 Regards, Stefi €˛Gnugs€¯ ezt Ć*rta: Have 2 pairs of cells representing two events -- a date and time for each event stored as text with the date cell in form mm/dd/yyyy and the time cell in form hh:mm xM. Need to find the elapsed time between the two events in hours and minutes placed in separate cells. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging separate date and time columns into one | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Worksheet Functions |