times and Calculations

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

professor_ed - 25 Sep 2007 00:14 GMT

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

Reply to this Message

Peo Sjoblom - 25 Sep 2007 00:30 GMT

=D1-C1

Signature

Regards,

Peo Sjoblom

> Hello!
> I want to calculate # of hours worked in this example:
[quoted text clipped - 4 lines]
>
> TKU

Reply to this Message

professor_ed - 25 Sep 2007 01:50 GMT

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

> =D1-C1
>
[quoted text clipped - 6 lines]
> >
> > TKU

Reply to this Message

Peo Sjoblom - 25 Sep 2007 05:06 GMT

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

Signature

Regards,

Peo Sjoblom

> Thank you for the speedy response! The result of the calculation was
> 5:00PM.
[quoted text clipped - 13 lines]
>> >
>> > TKU

Reply to this Message

David Biddulph - 25 Sep 2007 17:53 GMT

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.

Signature

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
[quoted text clipped - 8 lines]
>> as
>> hh mm ampm

>>> =D1-C1

>>> > 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.

Reply to this Message

Peo Sjoblom - 25 Sep 2007 17:57 GMT

Thanks for the heads up

Signature

Regards,

Peo Sjoblom

> But if you say it says 5:00PM, then I would expect it to convert to 17,
> not 5.
[quoted text clipped - 23 lines]
>>>> > D1 3:00 pm
>>>> > I want to display the duration of 5 hours.

Reply to this Message