Changing time entries from minutes to decimal

bgoodell · May 2nd, 2002, 03:23 PM

I have an excel timesheet that creates a total hour calculation after a range of in and out times are entered (cell format [h].mm). This works fine with one exception - the number of minutes are actually "minutes" and not decimal. For example - 7.5 hours shows as 7.30 when I had hoped that it would show as 7.5. I am sure that my cell formatting is the problem. I am not sure how to get the cell to see 60 minutes as %100 and 30 minutes as %50 on and on. Can anyone help a rookie?

Aladin Akyurek · May 2nd, 2002, 03:33 PM

=A1*24

where A1 houses a time value in the form 7:30.

Format the formula cell as General.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 2nd, 2002, 03:23 PM	#1
bgoodell New Member Join Date: Apr 2002 Location: Roseville, California Posts: 5	I have an excel timesheet that creates a total hour calculation after a range of in and out times are entered (cell format [h].mm). This works fine with one exception - the number of minutes are actually "minutes" and not decimal. For example - 7.5 hours shows as 7.30 when I had hoped that it would show as 7.5. I am sure that my cell formatting is the problem. I am not sure how to get the cell to see 60 minutes as %100 and 30 minutes as %50 on and on. Can anyone help a rookie?

May 2nd, 2002, 03:33 PM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	=A1*24 where A1 houses a time value in the form 7:30. Format the formula cell as General.