Converting Time 1

[bobnplano]

I am using Excel from Office 2000 Pro and would like to know how to convert time written as 1:30 (1 hr. 30 min) into hundredths (1.50). At work when I enter a start time & an end time there is a formula that calculates the time as in the example above. I am then required to convert that time into hundreths & enter it in the column next to it. Why they don't have it convert automatically is beyond me. I am forced to manually use a conversion table & re-enter the time in hundredths. Isn't there a simple conversion formula I can enter in the adjacent column where I have to enter this time in hundredths? The report I submit is actually on my PC & saved on my PC so why can't I put a formula on my PC in the application so I don't have to use a conversion chart? Any help would certainly be appreciated.

Thanks in advance,
Bob

 

[DaleWatson123321]

Bob,

Use this formula, which references Column A. But of course you can use it in whatever column you require - by just changing the column.

=(A1-INT(A1))*24

I hope this helps. Please advise as to how it fits.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca