Excel spreadsheet help
SteveR_100Milers
Posts: 5,987
Does anyone know how to convert standard time format of 00:00:00 (hr:mm:ss) into a decimal number? Excel help suggest using the Function <INT> but I can't get it to work.... :roll:
0
Comments
-
Format the cell where the result is shown as a "number" ; the default I think is "custom ". If you dont know how to format the cell . right click ; select "format cells"; in the category section of the number tab choose "number" and select the decimal places you want .0
-
In Excel, the date and time is stored as a decimal number with the date to the left of the decimal point and the time to the right, so when you use the Int() function, you are going to get either 0 or 1 as the result from a time value.
My suggestion would be to convert it into seconds since midnight with something like
=(Hours(Time)*3600)+Minutes(Time)*60)+Seconds(Time), assuming that Steve's solution isn't what you are looking for.0 -
If cell A1 is hh:mm:ss, in A2 put '=A1*24' and format A2 to be a normal number with however many decimals. This will result in 5.33 in A2 if A1 is 5:20:00.0
-
PS - the only reason I know this is from playing around with the Fred Whitton results. Are you doing something similar???
Please, reassure me that I'm not such a saddo after all.....0 -
Eureka shazz! Exactly what I need to do. Not quite for the same reasons as you did, I am making a chart showing the average speed required to hit specific times on a 10TT (and other TT distances).0
