How convert time entered into hours

On an Excel spreadsheet I am keeping track of start time and stop time.  For example...

Start time = 8:30
Stop time - 9:23

Then in the next column I am calculating the difference which using this example would be :53

But now in the column to the right of this calculated cell I want to to convert the :53 to hours, or in this case .88

What is the formula to handle this?

Who is Participating?
Deepak LakkadConnect With a Mentor Commented:

Keep 1:00 in one cell e.g. G8
You have 0:53 in other cell e.g. F9
You want 0.88 in one cell e.g. G9 then enter following formula in G9 cell


It will convert minutes into hours

- Deepak Lakkad
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.