Thread
:
Time (Hours) calculation
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
Posts: n/a
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....
Reply With Quote