Posted to microsoft.public.excel.worksheet.functions

Corey

Posts: n/a

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....

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time Calculation	Mike G	Excel Worksheet Functions	1	February 17th 06 10:50 PM
Adding time in hours	Jono	Excel Discussion (Misc queries)	2	September 22nd 05 12:46 PM
Time Calculation in Minutes only ?	pgcam	Excel Worksheet Functions	2	May 20th 05 07:35 PM
Time Calculation	chintu49	Excel Worksheet Functions	2	February 16th 05 02:55 PM
elapsed time calculation	rwf	Excel Discussion (Misc queries)	1	January 21st 05 04:51 AM

All times are GMT +1. The time now is 08:24 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us