convert time functions to numbers

Guest · Oct 31, 2006

I would like to convert hours and minutes to numbers. For example: 8:45 to 8.75

Guest · Oct 31, 2006

Try:
=A1*24

Format as a number

convert 8 hours and 45 min in to 8.75 hours.	1	Apr 7, 2008
Text to Numbers	3	Nov 5, 2008
Converting a number to hours and minutes	4	Apr 2, 2009
Decimal to Time Format.	5	Jul 30, 2008
Convert Percentage to total number of NPT Days	11	Apr 19, 2007
convert time to 1/4 hours	2	Feb 15, 2010
convert time to decimal	2	Jan 13, 2010
Converting time to decimal format	17	Nov 25, 2008

Ask a Question