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.

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.