Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Identifing total hours as a whole number
I have set up a little spreadsheet using "start time" and "end time". The
resulting difference is expressed in hours and minutes. I would like to use this figure to calculate pay. It is not doing that because of the formating. Is there a way? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Identifing total hours as a whole number
since one hour in Excel - 1/24 do as follows
=total_time*24*hourly_rate format as currency or else you'll get a weird time value -- Regards, Peo Sjoblom "Bob Morrison" wrote in message ... I have set up a little spreadsheet using "start time" and "end time". The resulting difference is expressed in hours and minutes. I would like to use this figure to calculate pay. It is not doing that because of the formating. Is there a way? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Identifing total hours as a whole number
Multiply the elapsed time by 24, (hours in a day) thus:
=(B1-A1)*24 and format as General or Number or to calculate the pay: =(B1-A1)*24* PAYRATE and format a currency. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Bob Morrison" wrote in message ... I have set up a little spreadsheet using "start time" and "end time". The resulting difference is expressed in hours and minutes. I would like to use this figure to calculate pay. It is not doing that because of the formating. Is there a way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
total hours vs total worked hours | Excel Discussion (Misc queries) | |||
How to seperate OT and Reg. Hours from total hours | Excel Worksheet Functions | |||
adding total number of hours in excel? | Excel Worksheet Functions | |||
Convert Total Hours and Minutes to Whole Number | Excel Worksheet Functions | |||
how to convert total hours (HH:MM) into decimal number | Excel Worksheet Functions |