formatting cells for a simple timesheet

[tamala60]

I'm trying to put together a simple time sheet for employees. It will calculate the daily hours but when I try to calculate the total hours for the pay period, I can't find the format that it will accept. I had a problem initially when the weekly hours exceeded 24, it zeroed out and started over. I fixed that but I'll be darned if I remember how. Maybe I need to format all the cells differently, but currently, the only problem I have is the total hours for the pay period. I couldn't find much information on this in any excel manuals I have.

 

[ChrisUK]

Because of the way excel stores date and time you can't have a period of over 24hrs - it doesn't exist. what does exist instead is days + hours

So, change your format to "dd hh:mm:ss"

HTH