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

=(B1-A1)*24

Format as General


"Spike9458" wrote:

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

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

On Jul 23, 5:24 pm, Spike9458 wrote:
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

Try,

With your time in A1

=A1*1440/60

Format as general.

Mike

"Spike9458" wrote:

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

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

Replace @mailinator.com with @tiscali.co.uk


"Spike9458" wrote in message
ups.com...
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

On Jul 23, 1:49 pm, "Sandy Mann" wrote:
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

Replace @mailinator.com with @tiscali.co.uk

"Spike9458" wrote in message

ups.com...



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- Hide quoted text -

- Show quoted text -

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

--Jim