Need help with subtracting time in Numbers
I am creating a spreadsheet to check that we have been paid correctly
Job involves shifts which have set start and finish times e.g.. 6:45am to 2:30pm with a 30min break
regularly we get called in early and might start anywhere from 15min to 3 hours early or later.
In the spreadsheet I have
(start time) A1. 6:45
(finish time) A2. 14:30
(Break) A3. 0.5
(result) A4 7.25 using the formula =a2-a1-a3
The meal break is in decimal and converts the answer to decimal which is how i require it.
The problem occurs when I try to add in extra work time
using above table i then add in
(start time) B1. 6:45
(finish time) B2. 14:30
(Break) B3. (empty)
(result) B4 22.25 using the formula =(a2-a1-a3)-(B2-B1-B3)
It is converting the extra time to 15 instead of 0.25.
If the extra time is over one hour e.g. 5:30 to 6:45 then it appears to work
another problem is when i add in the extra break time I get error because I can't subtract number value from time
Thanks in advance for you help
Numbers-OTHER, OS X Mavericks (10.9.5)