P
perplex
Hi all, be gentle this is my first post!
Ive been asked (if possible) to create a roster that automaticall
calculates the number of hours worked in prescribed period...
Ive been able to work out the basic hours
8.15 to 12.00 - 12.30 to 16.45 (12.00 minus 8.15) and (16.45 minu
12.30) then addting the two figures to get the daily total
However, being a roster/timesheet everything is either a full hour o
rounded to 1/2 and hour.
A colleague suggested: =IF(MOD(A1,1) <>0,INT(A1)+0.5,INT(A1))
to add the 0.5, if the hours worked is <> 0
However in the above scenario (8.15 to 16.45) works out to be 8.1, i
which case excel rounds up to 8.5. I would like it in that scenario t
round down...and i cant figure out how to do it!
Can anyone help me with this formula?
Thanks
perple
Ive been asked (if possible) to create a roster that automaticall
calculates the number of hours worked in prescribed period...
Ive been able to work out the basic hours
8.15 to 12.00 - 12.30 to 16.45 (12.00 minus 8.15) and (16.45 minu
12.30) then addting the two figures to get the daily total
However, being a roster/timesheet everything is either a full hour o
rounded to 1/2 and hour.
A colleague suggested: =IF(MOD(A1,1) <>0,INT(A1)+0.5,INT(A1))
to add the 0.5, if the hours worked is <> 0
However in the above scenario (8.15 to 16.45) works out to be 8.1, i
which case excel rounds up to 8.5. I would like it in that scenario t
round down...and i cant figure out how to do it!
Can anyone help me with this formula?
Thanks
perple