Displaying hours

[scottwilsonx]

Hello,
Ihave a spreadsheet with the times entered as 0800 for 8am and 1600 fo
4pm extra.

When I calculate the difference between the times I get 0800 for
hours, and so 2 days would be 1600, 3 days 2400 extra extra.

Is there a formula I can use to change the 2400 to display 24 hours ?

Thanks

Scott

 

[Bob Phillips]

Scott,
as long as the mins are 1 - 59, then this should be okay

=TIME(INT(A1/100),MOD(A1,100),1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Arvi Laanemets]

Hi

The best solution is to enter times in time format, like 08:00 and 16:00 -
then there will be no problems.

When data are imported from elsewhere, the better convert them. P.e. with
your time string in A2:
=TIME(LEFT(A2,2),RIGHT(A2,2),0)