Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formula question
Hi
I trying to do a simple time sheet on a spreadsheet, In seperate columns i have start time, end time, hours worked and hourly rate. In the last column i want to calculate the total pay by multiplying the hours worked by the hourly rate. Easier said than done. I have formatted the start time, end time and hour worked columns into HH:mm. The hours worked is calculated simply by subtracting the end time from start time. That gives me lets say 7:30 for 7 and half hours if i multiply this by say £7 per hour it gives me 2.19 as the answer. we all know this is not correct. What am i doing wrong and how can i correct this thanx Mark |
#2
|
|||
|
|||
In Excel time is stored as a fraction of a day. So one hour is 1/24.
Multiply your answer by 24, format as number and you'll be allright. -- Kind Regards, Niek Otten Microsoft MVP - Excel "Mark" wrote in message ... Hi I trying to do a simple time sheet on a spreadsheet, In seperate columns i have start time, end time, hours worked and hourly rate. In the last column i want to calculate the total pay by multiplying the hours worked by the hourly rate. Easier said than done. I have formatted the start time, end time and hour worked columns into HH:mm. The hours worked is calculated simply by subtracting the end time from start time. That gives me lets say 7:30 for 7 and half hours if i multiply this by say £7 per hour it gives me 2.19 as the answer. we all know this is not correct. What am i doing wrong and how can i correct this thanx Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
time formula question... | Excel Discussion (Misc queries) | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
formula Question | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |