| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I add time worked over days/wks/mon greater than 24 hours
I have hours employees have worked over periods of days, weeks and months.
I need to add times and get an answer that makes sense. Because sometimes in the one cell the answer may equate to less than or greater than 24hrs in any given day / week / month I need a formulae, function or format that I can work with effectively. I have tried IFing it, but because of the format it doesn't work out. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I add time worked over days/wks/mon greater than 24 hours
Jason,
You don't explain in what way your current answer doesn't make sense but maybe this helps. Adding time is as simple as =sum(range) and then to prevent hours in excess of 24 rolling over back to 1 use the format [h]:mm Mike "Jason" wrote: I have hours employees have worked over periods of days, weeks and months. I need to add times and get an answer that makes sense. Because sometimes in the one cell the answer may equate to less than or greater than 24hrs in any given day / week / month I need a formulae, function or format that I can work with effectively. I have tried IFing it, but because of the format it doesn't work out. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I add time worked over days/wks/mon greater than 24 hours
Custom format the total cell to [h]:mm:ss
Right clickFormatCellsCustom If this post helps click Yes --------------- Jacob Skaria "Jason" wrote: I have hours employees have worked over periods of days, weeks and months. I need to add times and get an answer that makes sense. Because sometimes in the one cell the answer may equate to less than or greater than 24hrs in any given day / week / month I need a formulae, function or format that I can work with effectively. I have tried IFing it, but because of the format it doesn't work out. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I add time worked over days/wks/mon greater than 24 hou
THANKS THAT WORKED WELL.
Is there any way to hide the seconds like decimal points? "Jacob Skaria" wrote: Custom format the total cell to [h]:mm:ss Right clickFormatCellsCustom If this post helps click Yes --------------- Jacob Skaria "Jason" wrote: I have hours employees have worked over periods of days, weeks and months. I need to add times and get an answer that makes sense. Because sometimes in the one cell the answer may equate to less than or greater than 24hrs in any given day / week / month I need a formulae, function or format that I can work with effectively. I have tried IFing it, but because of the format it doesn't work out. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| time sheet needed to total weekly hours worked by staff | Excel Discussion (Misc queries) | |||
| Converting Millitary Time to Hours worked and OT hours | Excel Worksheet Functions | |||
| Creating Bi-Weekly Time Sheet to Calculate Hours Worked | Excel Discussion (Misc queries) | |||
| Calculate Total hours worked during workdays within given shift time. | Excel Discussion (Misc queries) | |||
| time format multiplied by hours worked ? | Excel Worksheet Functions | |||
Linear Mode
