Difficult Time equation

B

bcbjork

This is my first post so hello everyone and thankyou in advance for an
assistance you can provide.

The diffuclty I am having is as follows:

I have a spreadsheet with two times


8:45 9:45

I need to find the difference in the two times as a decimal but as
fraction of an hour..

for thesee times the answer I need is 0.25 not 0.15.

Can anyone help
 
B

Bob Phillips

Time is stored as a fraction of a day, so just multiply by 24 to get decimal
time.

In your case

=(B1-A1)*24

although I get 1, not .25

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top