I have an equation "Hour(A1)+Minute(A1)/60" where I want to convert the time
(A1) into its decimal equivalent. (A1 is formatted as a number of type
Time.) However, this only works as long as A1 is less than 24:00. Otherwise,
Hour(A1) starts subtracting 24 from the actual horns. For example,
Hour(30:00) returns 6 rather than 30. Is there an alternate function that
will do this?

Excel 97

Thanks,
Don Culp