times and Calculations

[professor_ed]

Hello!
I want to calculate # of hours worked in this example:

C1 10:00 am
D1 3:00 pm
I want to display the duration of 5 hours.

TKU

 

[Peo Sjoblom]

=D1-C1


--


Regards,


Peo Sjoblom

 

[professor_ed]

Thank you for the speedy response! The result of the calculation was 5:00PM.
I need the result to be 5. I tried changing the values of thr receiving
cells, but could not get the result to show 5. Cells C1 & D1 are defines as
hh mm ampm

 

[Peo Sjoblom]

if you want it to be 5 decimal format you need to multiply the result with
24 and format the cell as general or number (not time), if you want 05:00 as
a result you need to format the result as hh:mm

=(D1-C1)*24


formatted as general will return 5
--

Regards,

Peo Sjoblom

 

[David Biddulph]

But if you say it says 5:00PM, then I would expect it to convert to 17, not
5.
If your original inputs were 10:00 am and 3:00 pm, then if you have the
result cell formatted as h:mm AM/PM, the formula =D1-C1 ought to display as
5:00 AM (not PM), but to get it to show 5:00, you can change the format to
[h]:mm. To convert to decimal hours, use Peo's formula.

 

[Peo Sjoblom]

Thanks for the heads up


--


Regards,


Peo Sjoblom

But if you say it says 5:00PM, then I would expect it to convert to 17,
not 5.
If your original inputs were 10:00 am and 3:00 pm, then if you have the
result cell formatted as h:mm AM/PM, the formula =D1-C1 ought to display
as 5:00 AM (not PM), but to get it to show 5:00, you can change the format
to [h]:mm. To convert to decimal hours, use Peo's formula.
--
David Biddulph

if you want it to be 5 decimal format you need to multiply the result
with 24 and format the cell as general or number (not time), if you want
05:00 as a result you need to format the result as hh:mm

=(D1-C1)*24
formatted as general will return 5