Simple hours calculated and then multiplied or subtracted from

mtaylor

Board Regular
Joined
May 1, 2013
Messages
80
Office Version
  1. Prefer Not To Say
Platform
  1. Windows
  2. MacOS
Hi,

Little embarassed to be asking this but here goes:

I'm trying to work out nursery costs for the future. I have a start time entered, and a finish time (0730 - 1630) this gives me 9 hours which I have set as duration - it comes out as 09:00:00 (not ideal but sufficient)

I have totalled that column to equal 36 (36:00:00) again not a massive issue.

My problem not comes when I want to subtract 30 from that total. It should obviously equal 6, but for some reason it equals -684:00:00

Things also go Pete Tong when I try and calculate the daily cost, by multiplying the 09:00:00 by the hourly cost (it shows the 0.38 instead of 9 to begin with).

Thanks all
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
change your initial calc to =(B2-A2)*24 and then the rest of the calcs should work for you if the start and end times are in row 2
 
Upvote 0
Solution
change your initial calc to =(B2-A2)*24 and then the rest of the calcs should work for you if the start and end times are in row 2
Yep - brilliant, thank you.
I also had to change the format to 'number' which was actually preferable as it took away the multiple 0's at the end.

Thanks again
 
Upvote 0

Forum statistics

Threads
1,226,287
Messages
6,190,059
Members
453,592
Latest member
bcexcel

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top