| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I need calculated time in a "real number" format
Hello everyone...this is my first time using the forum. Hopefully you can
help. I am calculating the difference between two times in a spreadsheet to arrive at the number of hours an employee works during the day. I then want to multiply that times their hourly rate to arrive at the payroll cost. Of course, this does not work because Excel sees the calculated difference as a decimal instead of the number of hours. Can anyone tell me how I can turn the calculated time difference into a number I can use to calculate the payroll cost.... Example 10 am - 2 p.m. = 4 hours for day 4 * $15 = $60 payroll cost. Thank you! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need calculated time in a "real number" format
Hi,
Subtract the times and multiply by 24 to get decimal hours so =(B1-A1)*24*15 Wii return 60 Mike "MRH" wrote: Hello everyone...this is my first time using the forum. Hopefully you can help. I am calculating the difference between two times in a spreadsheet to arrive at the number of hours an employee works during the day. I then want to multiply that times their hourly rate to arrive at the payroll cost. Of course, this does not work because Excel sees the calculated difference as a decimal instead of the number of hours. Can anyone tell me how I can turn the calculated time difference into a number I can use to calculate the payroll cost.... Example 10 am - 2 p.m. = 4 hours for day 4 * $15 = $60 payroll cost. Thank you! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
I need calculated time in a "real number" format
I forgot, format as General
"Mike H" wrote: Hi, Subtract the times and multiply by 24 to get decimal hours so =(B1-A1)*24*15 Wii return 60 Mike "MRH" wrote: Hello everyone...this is my first time using the forum. Hopefully you can help. I am calculating the difference between two times in a spreadsheet to arrive at the number of hours an employee works during the day. I then want to multiply that times their hourly rate to arrive at the payroll cost. Of course, this does not work because Excel sees the calculated difference as a decimal instead of the number of hours. Can anyone tell me how I can turn the calculated time difference into a number I can use to calculate the payroll cost.... Example 10 am - 2 p.m. = 4 hours for day 4 * $15 = $60 payroll cost. Thank you! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel and "Real-time" feed | Excel Discussion (Misc queries) | |||
| How can I format elapsed time as "[mm]: ss" without getting "AM PM | Excel Discussion (Misc queries) | |||
| can "real time" be cell function in EXCELL? | Excel Worksheet Functions | |||
| Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) | |||
| Properties "Total Editing Time" not calculated | Setting up and Configuration of Excel | |||
Linear Mode
