# 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

### Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

#### 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.