Convert time to fraction of an hour

[Patrick C. Simonds]

I have 2 time columns from which I subtract the high time from the low time
to give me the total time elapsed. So if I subtract 12:11 from 12:34 I get
:23 (or 23 minutes). What I need to be able to do is convert that :23 to the
fraction part of the hour. In this case .383

 

[T. Valko]

Try this:

A1 = 12:11
B1 = 12:34

=(B1-A1)*24

Format as GENERAL or NUMBER