Converting hours and minutes into hours and tenths

[racefankevin]

Here at work we are on the hours and tenth's hourly clock.

I can not find a formula to convert hours and minutes into hours and tenths.

Any help would be greatly appreciated. Along with Thank you in advance.

Kevin

 

[MrTeeny]

I'm not accustomed with tenths, how are they displayed i.e. is it a tenth of an hour, 6 minutes? how would 1 minute be displayed?

Shouldn't be hard to do as you can get the hours and minutes separately from a cell by simply using =HOUR(A1) & " Hours " & MINUTE(A1)/6 & " Tenths " . SHould be relatively easy to format it from there depending on how you want them to display i.e. =HOUR(A1) & " " & ROUNDDOWN(MINUTE(A1)/6,0) & "/10" & " Hours " and so on

 

[racefankevin]

Yes, a tenth of an hour.

 

[MrTeeny]

K, dividing the MINUTE(A1) by 6 will give you the tenth of an hour, from there it just depends how you want it displayed if you want it as whole tenths rounded down =ROUNDDOWN(MINUTE(A1)/6,0) if you wants those displayed as fractions =ROUNDDOWN(MINUTE(A1)/6,0) & "/10"

How do you want 2 hours 9 minutes to display?

 

[racefankevin]

Hmmm... great question. I just have been using the round function on items instead of the round up and round down.

 

[Dave Patton]

Excel 2010
	A	B
1	2:30	2.50
2	10:09	10.15
3	7:15	7.25
4
1b

Cell Formulas
Range	Formula
B1	=A1*24

Ensure that you format the result as a number.

 

[ScottBach]

I bill my clients by 1/10 of an hour rounded up, but my timekeeping program enters the elapsed time as XX: XX: XX which I need converted into XX.X so I can then multiply that by my billing rate to get a charge for that activity. That is the formula I need. Can anyone help?

 

[ScottBach]

I would want that displayed as 2.2

 

[ScottBach]

I would want that displayed as 2.2

 

[Dave Patton]

ScottBach Your question is not clear. Provide some examples with expected results.

Excel 2010
	A	B	C
1	2:30	2.50	2.5
2	10:09	10.15	10.2
3	7:15	7.25	7.3
4
5
1e

Cell Formulas
Range	Formula
B1	=A1*24
C1	=ROUNDUP(A1*24,1)