Time Question

[Spike9458]

10:00 am - 3:30 pm = 5:30 (5 hours and 30 minutes)

How do I convert the 5 hours and 30 minutes to 5.5 hours? I have tried
different formats but have not been able to get it right.

Thanks

--Jim

 

[Pete_UK]

Multiply by 24 and format the cell as a number with 2 decimal places.
Excel stores hours as fractions of a day.

Hope this helps.

Pete

 

[Guest]

=(B1-A1)*24

Format as General

 

[Guest]

Try,

With your time in A1

=A1*1440/60

Format as general.

Mike

 

[Sandy Mann]

1 hour is 1/24th of a day so multiply the result by 24 to get decimal
numbers.

For example with your 10:00 AM in A2 and 3:30 PM in B2 use:

=(B2-A2)*24


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Spike9458]

1 hour is 1/24th of a day so multiply the result by 24 to get decimal
numbers.

For example with your 10:00 AM in A2 and 3:30 PM in B2 use:

=(B2-A2)*24

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk







- Show quoted text -

Thank-you to you all for your answers ... *24 seems to be the simplest
way to do it for me.

--Jim