Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet help
Am using Excel to keep a record of hours worked by 9 people who perform a
variety different tasks daily. The start time and end time are entered in hh.mm format and the time taken for each job is recorded. Weekly totals come to more than 24 hours and so are expressed incorrectly, because the hh.mm format will not recognice more than 24 hours. I cannot find the correct method or formula to show in the "total cell" that eg. 39 hours 18 minutes has been taken to do a particular type of job. Can anyone point me in the right direction. Thanks in anticipation. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet help
Hi,
That's a simple format issue. Formatting as [hh]:mm stops the hours rolling over at 24. Mike "The Golfer" wrote: Am using Excel to keep a record of hours worked by 9 people who perform a variety different tasks daily. The start time and end time are entered in hh.mm format and the time taken for each job is recorded. Weekly totals come to more than 24 hours and so are expressed incorrectly, because the hh.mm format will not recognice more than 24 hours. I cannot find the correct method or formula to show in the "total cell" that eg. 39 hours 18 minutes has been taken to do a particular type of job. Can anyone point me in the right direction. Thanks in anticipation. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Timesheet help
Custom format the total cell to [h]:mm ..
Right clickFormatCellsCustom... -- If this post helps click Yes --------------- Jacob Skaria "The Golfer" wrote: Am using Excel to keep a record of hours worked by 9 people who perform a variety different tasks daily. The start time and end time are entered in hh.mm format and the time taken for each job is recorded. Weekly totals come to more than 24 hours and so are expressed incorrectly, because the hh.mm format will not recognice more than 24 hours. I cannot find the correct method or formula to show in the "total cell" that eg. 39 hours 18 minutes has been taken to do a particular type of job. Can anyone point me in the right direction. Thanks in anticipation. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TIMESHEET | Excel Worksheet Functions | |||
Timesheet - | Excel Discussion (Misc queries) | |||
Timesheet | Excel Worksheet Functions | |||
Timesheet help | Excel Worksheet Functions | |||
Timesheet | Excel Worksheet Functions |