Time Conversion

Lucy89

Board Regular
Joined
Jan 25, 2009
Messages
88
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
 

Some videos you may like

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
Joined
May 7, 2008
Messages
21,758
Office Version
2010
Platform
Windows
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
Joined
Jan 25, 2009
Messages
88
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 :)
 

shg

MrExcel MVP
Joined
May 7, 2008
Messages
21,758
Office Version
2010
Platform
Windows
You're welcome.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,105,868
Messages
5,507,832
Members
408,648
Latest member
B99

This Week's Hot Topics

Top