| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I calculate Costs from a Time. ie 16:00 - 12:00 = 4:00hrs x £5.50rate per hour = £22.00
|
|
#2
|
|||
|
|||
|
=(end time - start time) * rate per hour * 24
HTH. Best wishes Harald "Eric Nicoll" skrev i melding ... |
|
#3
|
|||
|
|||
|
Time dates are represented at the "rate" of 1 = 1 day. So
1/24 id the equivalent of 1 hour, so time2-time1 /(1/24) gives you the number of hours (and pro-rata for any minutes/seconds. You may want to use the round function to modify this. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you subtract military time? example 12:00 - 07:00 = 5 hour. | Excel Worksheet Functions | |||
Linear Mode
