# Time Conversion

#### Lucy89

##### Board Regular
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

#### shg

##### MrExcel MVP
 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​

#### Lucy89

##### Board Regular
 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​

<tbody>
</tbody>
shg that works fantastically well! Thank you so much

You're welcome.