View Single Post
  #9   Report Post  
George Nicholson
 
Posts: n/a
Default

How are your cells formatted?

Under FormatCellsNumberTime: "37:30:55" would display 120:30:00 for 5
days, 30 minutes.
This is the same as FormatCellsNumberCustom: [h]:mm:ss

Alternatively, the John Walkenbach sheet that Frank directed you to uses a
Custom format [h]:mm. This would display as 120:30

HTH,
--
George Nicholson

Remove 'Junk' from return address.


"Tony" wrote in message
...
Hi Frank,

what have I to do, if I want to display in the summary of total hours more
than 24 hours? I have created my own timesheet and if I have in the
summary
of total hours more than 24, it doesn't work correctly.

Thanks.

Tony

Frank Kabel píse:

Hi
as starting point:
http://j-walk.com/ss/excel/files/timesht.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve Lindsay" <Steve schrieb im
Newsbeitrag ...
Need to create an Excel Timesheet that calculates the hours and

minutes
worked daily, based on the time-in/time-out. Then allow the

calculated daily
time to total for the week. Am having to make Excel jump through

hoops so
far. Any ideas/suggestions?