# Thread: Time Conversion Thanks: 0 Likes: 0

1. ## Time Conversion

Hi

I have the following problem. I am trying to automate a time-sheet but I am having a problem converting .30hrs to 0.50hrs.

For example:
C4 I have the start time 08.00
D4 I have the finish time 08.30
E4 I have D4-C4 which equals 0.30

C4 I have the start time 08.00
D4 I have the finish time 08.15
E4 I have D4-C4 which equals 0.15

C4 I have the start time 07.45
D4 I have the finish time 08.30
E4 I have D4-C4 which equals 0.85

Is it possible to convert .30 to display 0.50, 0.15 to display 0.25 and 0.85 to display as 0.75.

This would help with adding the weekly hours.

Thank you very much,

L

2. ## Re: Time Conversion

 c d e f 4 8.00 8.30 0.50 e4: =dollarde(d4, 60) - dollarde(c4, 60) 5 8.00 8.15 0.25 6 7.45 8.30 0.75

3. ## Re: Time Conversion

Originally Posted by shg
 c d e f 4 8.00 8.30 0.50 e4: =dollarde(d4, 60) - dollarde(c4, 60) 5 8.00 8.15 0.25 6 7.45 8.30 0.75
shg that works fantastically well! Thank you so much

4. ## Re: Time Conversion

You're welcome.