Time Format

[Ed]

Help please!!!!

Im stuck with a formula to work out the total hours worked
on a spreadsheet.

My Daily Totals are formatted with the h:mm format but
when i total the months time it formats it to a 24hr clock
so 30hrs will be displayed as 06:00!!!!

Help please i am in danger of my sanity.

Thanks

 

[Don Guillett]

an hour is 1/24 of a day

 

[Arvi Laanemets]

Hi

Format as "[h]:mm"

 

[Bob Phillips]

Format the cell as [h]:mm

--

HTH

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

 

[Guest]

This will bring up a total of 1.25 days but what i want is
the total hours i have worked in the month ie 30:00 not
06:00 what it is displayed at the moment.

Thanks again for your help

 

[Guest]

This will bring up a total of 1.25 days but what i want is
the total hours i have worked in the month ie 30:00 not
06:00 what it is displayed at the moment.

-----Original Message-----
Format the cell as [h]:mm

--

HTH

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

Help please!!!!

Im stuck with a formula to work out the total hours worked
on a spreadsheet.

My Daily Totals are formatted with the h:mm format but
when i total the months time it formats it to a 24hr clock
so 30hrs will be displayed as 06:00!!!!

Help please i am in danger of my sanity.

Thanks

.

 

[Peo Sjoblom]

Use the format [h]:mm instead of h:mm, that way the hours will roll over and
to start again after 24 hours

 

[Ron Rosenfeld]

This will bring up a total of 1.25 days but what i want is
the total hours i have worked in the month ie 30:00 not
06:00 what it is displayed at the moment.

-----Original Message-----
Format the cell as [h]:mm

Have you tried the suggested formatting?

What do you see in the cell?


--ron