24 hour clock formula for elapsed time between 1215 and 1630
 

I would expect to see something like either 4.25 or 4:15 or ??

24 hour clock formula for elapsed time between 1215 and 1630
 

With 16:30 in A1 and 12:15 in B1, put this in C1
=A1-B1
to get the difference 4:15

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"Tader" wrote:

I would expect to see something like either 4.25 or 4:15 or ??