Thread: Time (Hours) calculation

I want to be able to place a time & date in one cell,
Place a total hour figure in another cell,
and a result in (Time & Date) placed into a 3rd cell.
How would i do this if say:
EG.
A1= 6:00:00 14 June 2006
B1=49.5 hrs
C1= (7:30:00 16 June 2006) Calculated result.

Corey....

Enter B1 as 49:30

Then you can calculate in C1:
=A1+B1

HTH
--
AP

"Corey" <coreymcconnell@splicetech.com.au> a écrit dans le message de news:
Ofz3vuQkGHA.4444@TK2MSFTNGP02.phx.gbl...
>I want to be able to place a time & date in one cell,
> Place a total hour figure in another cell,
> and a result in (Time & Date) placed into a 3rd cell.
> How would i do this if say:
> EG.
> A1= 6:00:00 14 June 2006
> B1=49.5 hrs
> C1= (7:30:00 16 June 2006) Calculated result.
>
> Corey....
>