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