Excel Time Conversion

If the time is stored as a number, 0 to 24 hours will be represented by a number in the range 0 to 1.

Hope this example makes sense to you:

(N.B. this is on a PC - may be different on a Mac).

Here's another approach:-

Excel stores the time/date data as a digital number, "date.time" where the whole part of the number represents the number of days since, I believe, January 1, 1900, while the fractional part of the number represents the time as a fractional part of a 24 hour period. First thing to do is to insure the data stored in the cells containing the time data do not also include date information: change the format of the cell to "number" (format menu, cells, number). If your results are consistently less than 1, then multiply this number by 24, which gives you the hours since midnight (0:0:0) as a decimal number. If all of your time values are less than 1 hour and you want the value as minutes instead of hours, multiply by 1440. For seconds, multiply by 86400. You do not have to reformat the cells containing the time data for this to work. The only reason we change the format of the cell to number is to verify that the value does not include embedded date numbers. Examples:

T

No need to convert the time entry, other than to insure it does not include embedded date information as well. If the time entry has the date embedded, one must operate only on the fractional part of the number. If the time data is stored with date information, you can strip the date from the number by using the formula:

=(A3-INT(A2))*c

Where c is 24, 1440 or 86400, depending on whether you want hours, minutes or seconds.

Disclaimer: This works in Excel 2000 and OpenOffice/LibreOffice Calc. No telling what MS has done to pervert the operation in newer versions of Excel.