time over 1 hour

  • Thread starter Thread starter johnfli
  • Start date Start date
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
 
Excel counts one day as 1. Therefore 1 hour = 1/24. Try something like

=A1-(1/24)

Rgds,
Andy
 
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
 
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...
 
Back
Top