Thread: Time format for workschedule

Hi, I'm looking for some help
I'm looking to calculate timesheets, but instead of 2:15 in format of 2
hours 15 minutes, I'm looking to save as 2.25 where it's 2 hours and 0.25
hours
I would take calculations from Cell A1 as start time of 8:00 AM and Cell A2
end time of 10:15 AM and result in Cell A3.
any suggestions?

Lifegaurd

=(A2*24)-(A1*24)

formatted as 'general'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Lifeguard" <Lifeguard@discussions.microsoft.com> wrote in message
news:FF061C33-6684-4E82-9995-87957553F640@microsoft.com...
> Hi, I'm looking for some help
> I'm looking to calculate timesheets, but instead of 2:15 in format of 2
> hours 15 minutes, I'm looking to save as 2.25 where it's 2 hours and 0.25
> hours
> I would take calculations from Cell A1 as start time of 8:00 AM and Cell
> A2
> end time of 10:15 AM and result in Cell A3.
> any suggestions?