Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding the total hours worked in 5 weeks
I'm making a time sheet to keep track of the time I've worked and most of it
is finished but I cant get the total hours, the program counts the hours as a day if it reaches over 24 hours. The total hours should be 82 hrs (10mins) but it shows as 1/4/1900 5:06.... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding the total hours worked in 5 weeks
Right click the total cell. Format CellsCustom Type
[h]:mm If this post helps click Yes --------------- Jacob Skaria "Tisheina" wrote: I'm making a time sheet to keep track of the time I've worked and most of it is finished but I cant get the total hours, the program counts the hours as a day if it reaches over 24 hours. The total hours should be 82 hrs (10mins) but it shows as 1/4/1900 5:06.... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
adding the total hours worked in 5 weeks
Hi,
change the format of the time cells to [h]:mm:ss You can do this by choosing Format, Cells, Number tab, Custom and entering the above on the Type line or hunting it down in the list while Custom is selected. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Tisheina" wrote: I'm making a time sheet to keep track of the time I've worked and most of it is finished but I cant get the total hours, the program counts the hours as a day if it reaches over 24 hours. The total hours should be 82 hrs (10mins) but it shows as 1/4/1900 5:06.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function to calculate total hours worked in one week. | Excel Worksheet Functions | |||
In Excell how can i get a total hours worked value from 2 times? | Excel Worksheet Functions | |||
total Hours Worked for week PS thx for the formulars everyone! | Excel Worksheet Functions | |||
Adding Hours worked | Excel Discussion (Misc queries) | |||
Getting a total of hours & mins worked per week | New Users to Excel |