time over 1 hour

J

johnfli

I have a cell that displays teh amount of time a person waited at a certain
place.

For example, 1:30 for 1 hour, 30 min.

I need to have another cell that will tell me the time above one hour, in
this case, :30



Thanks
 
A

Andy Brown

Excel counts one day as 1. Therefore 1 hour = 1/24. Try something like

=A1-(1/24)

Rgds,
Andy
 
P

Peo Sjoblom

With the time in A1

=MOD(A1,1/24)

or if it 02:30 should be 01:30 over one hour

=A1-TIME(1,,)


format as hh:mm
 
J

johnfli

works great!!
Thanks!!


Peo Sjoblom said:
With the time in A1

=MOD(A1,1/24)

or if it 02:30 should be 01:30 over one hour

=A1-TIME(1,,)


format as hh:mm

--

Regards,

Peo Sjoblom
Click to expand...
 
Top