Work with dates

Turn a time into decimal hours

How it works in Excel

• Excel stores a time as part of a day.
• Multiplying by 24 gives hours.
• Format the cell as Number.
• Multiply by 1440 for minutes.

The idea in general

A full day is 1, so 1.5 hours is a small slice of that.

What I assumed

• The time is in A2.

Check the result on your own data before relying on it.