Time Question

S

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
 
P

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
 
S

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
[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

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
[email protected]
Replace @mailinator.com with @tiscali.co.uk







- Show quoted text -
Click to expand...

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

--Jim
 
Top