times and Calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
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.
 
Thanks for the heads up


--


Regards,


Peo Sjoblom



David Biddulph said:
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

Peo Sjoblom said:
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
Click to expand...
Click to expand...
 
Back
Top