Don't want rounding if possible

[philky001]

I have an excel sheet which we use to calculate employees work schedules.
I have a formula which calculates hours, taking into account second shift times, some work 2-10 pm etc.

=IF(OR(D5=""|C5="")|""| IF(D5=C5|12|IF(ABS(D5-C5)<>0|IF((D5-C5+12)>12| D5-C5| D5-C5+12)|0)))

Now there is new group which schedules for instance 7.50am. The excel is showing this as 8.
I would like to calculate this as 7.50am.

Not only this but when i enter 7.50 it shows 8 but also doesnt do the total correctly. I have an ending time of 5 and it's showing the total as 10 not 9. or 9.10

 

[oldbrewer]

help us by pasting A1 to F10 please - and why vertical separators instead of commas

 

[philky001]

The data looks like this. We have weekly totals and monthly. I enter all the days of the month. 8 is the starting time 8am till 2pm. I would like to be able to enter 7.50am.

Dept Month: Sept 2017 1 Total
In Out
Staff
0
Call Room Shaneice 8 2 6
Marsha 8
Christina 8 4 8
Jessica 8 4 8

 

[oldbrewer]

try bordering the data and paste it again - it is scrambled

 

[oldbrewer]

or format the cells as custom hh:mm