Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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.... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time Calculation | Excel Worksheet Functions | |||
Adding time in hours | Excel Discussion (Misc queries) | |||
Time Calculation in Minutes only ? | Excel Worksheet Functions | |||
Time Calculation | Excel Worksheet Functions | |||
elapsed time calculation | Excel Discussion (Misc queries) |