View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default Time (Hours) calculation

Enter B1 as 49:30

Then you can calculate in C1:
=A1+B1

HTH
--
AP

"Corey" a écrit dans le message de news:
...
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....