Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with cell formatting
I'm creating a timesheet for our payroll system. I have a row where
employees enter the times they punch in and out each day then at the end of the row there is a function to automatically total the number of hours worked. My problem is that the punch-in and punch-out entries are in an (h:mm) format and I need the cell containing the total to be in a decimal format. How do I format it so that working 8 hours and fifteen minutes shows up in the total column as 8.25 rather than 8.15? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with cell formatting
Start in A1
End in B1 Format C1 to General or Number, then enter =MOD(B1-A1,1)*24 The Mod is for times spanning midnight. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "bwpark" wrote in message ... I'm creating a timesheet for our payroll system. I have a row where employees enter the times they punch in and out each day then at the end of the row there is a function to automatically total the number of hours worked. My problem is that the punch-in and punch-out entries are in an (h:mm) format and I need the cell containing the total to be in a decimal format. How do I format it so that working 8 hours and fifteen minutes shows up in the total column as 8.25 rather than 8.15? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with cell formatting
Assuming that the times are real XL times then to turn tham into decimal
numbers multiply the total by 24 -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "bwpark" wrote in message ... I'm creating a timesheet for our payroll system. I have a row where employees enter the times they punch in and out each day then at the end of the row there is a function to automatically total the number of hours worked. My problem is that the punch-in and punch-out entries are in an (h:mm) format and I need the cell containing the total to be in a decimal format. How do I format it so that working 8 hours and fifteen minutes shows up in the total column as 8.25 rather than 8.15? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) |