View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Corey
 
Posts: n/a
Default 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....