times and Calculations
 

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

times and Calculations
 

=D1-C1


--


Regards,


Peo Sjoblom




"professor_ed" wrote in message
...
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

times and Calculations
 

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" wrote:

=D1-C1


--


Regards,


Peo Sjoblom




"professor_ed" wrote in message
...
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

times and Calculations
 

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




"professor_ed" wrote in message
...
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" wrote:

=D1-C1


--


Regards,


Peo Sjoblom




"professor_ed" wrote in message
...
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

times and Calculations
 

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" wrote in message
...
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
--
"professor_ed" wrote in message
...
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" wrote:

=D1-C1

"professor_ed" wrote in message
...
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.

times and Calculations
 

Thanks for the heads up


--


Regards,


Peo Sjoblom



"David Biddulph" <groups [at] biddulph.org.uk wrote in message
...
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" wrote in message
...
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
--
"professor_ed" wrote in message
...
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" wrote:

=D1-C1

"professor_ed" wrote in message
...
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.