How do I calculate Costs from a Time. ie 16:00 - 12:00 = 4:00hrs x £5.50rate per hour = £22.00

B

Ben McBen

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calculate difference between two date & time along with working hours and days 2
how do I calculate a week days hours with the 24hour clock 5
Conditional Time Calculation 10
display time in 12 hour format 1
Excel Facetime Measurement 1
calculate overtime at 2 different rates 5
Calculate hours, past midnight etc 4
Still problems with calculation of time 5

Top