elapsed time

A

ash

i have 2 different static times and i want to calculate
the elapsed time between them but i only want to work out
the hrs and mins not the secs is there a way 2 do this?
 
P

Peo Sjoblom

This will round to the nearest minute

=ROUND((B2-A2)/(1/1440),0)*1/1440

if you want to take off all seconds before the subtraction use

=FLOOR(B2,"0:1")-FLOOR(A2,"0:1")

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Top