Converting "time" to "whole number" I.E. 12:30 to 12.5??? How

[tass]

I am making a "Timesheet" spreadsheet to track employees time. I am
trying to get excel to take the number of hours a person has worked
and convert it. Example: taking an average work day of 8.5 hours and
displaying it as 8.5 and not 8h 30m. Currently excel diplays the time
as hours and minutes what I want is hours and parts of hours .25,.5,
..75.
How does one do this???

 

[Bernard Rey]

tass wrote :

I am making a "Timesheet" spreadsheet to track employees time. I am
trying to get excel to take the number of hours a person has worked
and convert it. Example: taking an average work day of 8.5 hours and
displaying it as 8.5 and not 8h 30m. Currently excel diplays the time
as hours and minutes what I want is hours and parts of hours .25,.5,
.75.
How does one do this???

Suppose your 8:30 time is in cell A1. In cell B1 (or any other) type:
"=A1*24" (without the quotes).

Then go to the "Format" > "Cells..." item. In the "Number" tab, select the
"General" setting, click "OK" and there you should read "8,5" in B1.

For more information about how Excel deals with dates and time, check the
helpfile.

 

[tass]

Thank you for the piece of the puzzle that got me over the hump...
Rock On, Ray