Time Format

  • Thread starter Thread starter Ed
  • Start date Start date
E

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
 
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)
 
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
 
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
Click to expand...


.
Click to expand...
 
Use the format [h]:mm instead of h:mm, that way the hours will roll over and
to start again after 24 hours
 
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
Click to expand...
Click to expand...


Have you tried the suggested formatting?

What do you see in the cell?


--ron
 
Back
Top