| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Time Sheets
When I am doing the formula =SUM(H7:H15)*24 on my time sheet and setting the total to numbers so that it gives me the correct totals the formula is making my sheet go out I think it is rounding the totals up with having to multiply by 24 to get the sheet working right. Can any one help me get this right as I cannot have my sheet rounding up by as much as 13 minutes on some times. Helen -- Helen Black |
|
#2
|
|||
|
|||
|
Hi Helen
can you type out an example of when it's rounding as i've not noticed this when i've used this method cheers JulieD "Helen Black" wrote in message ... When I am doing the formula =SUM(H7:H15)*24 on my time sheet and setting the total to numbers so that it gives me the correct totals the formula is making my sheet go out I think it is rounding the totals up with having to multiply by 24 to get the sheet working right. Can any one help me get this right as I cannot have my sheet rounding up by as much as 13 minutes on some times. Helen -- Helen Black |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| formulas for employee time sheets | Excel Worksheet Functions | |||
| HOW CAN I CHANGE SET-UP ON MULTIPLE SHEETS AT 1 TIME? | Setting up and Configuration of Excel | |||
| set or reset the print range for several sheets at a time? | Excel Discussion (Misc queries) | |||
| Setting up scheduling and Time sheets for Payroll | Excel Worksheet Functions | |||
Hybrid Mode
