calculating times in 15 minute increments

Avatar

Avatar

Gene--O

Avatar

Gene--O

Gene--O

09-09-2013

Good Afternoon,

I am making a form where we report how much leave is being used. The leave will be reported in 15 minute increments. (Ex: fifteen minutes = .15; one-half hour = .30; 45 minutes = .45) I need to be able to add these up and have them keep this format of 15 minute increments. Also, I need the display to be a decimal instead of a colon, if possible. (Ex. 3.45 instead of 3:45).

any advice is appreciated!!!

Gene-O

View Entire Topic

Avatar

Avatar

Gene--O

Avatar

Gene--O

Gene--O

10-09-2013

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