Avatar

Level 4

Thanks so much for trying to help!!

I need to calculate leave taken by an employee in 15 minute intervals.

For example:

1.15 hours of vacation (one hour and fifteen minutes)

+2.30 hours of holiday leave (two hours and thirty minutes)

+ 4.45 hours of sick leave (four hours and forty-five minutes)

= 8.30 hours of total leave taken (eight hours and thirty minutes)

Anything I try has calculated it as:

1.25

2.50

4.75

=8.50

I have to have it formatted in 15 minute increments instead of decimals

Any ideas?

Gene-O