Adding hours to a date

Rich

Posts: n/a

Adding hours to a date

Hi,

I want to add a number of hours to a date and a time and have Excel give me
the resulting date and time. The hours that I will want to add to the date
could be
anything, including part days, eg 3.25 hours, 92.4 hours, and so on.

For instance

1st Dec 2004 13:00

Add 50.5 hours

Result: 3rd Dec 2004 15:30

What is the formula that I need to achieve this?

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
Date updates from worksheet to chart & changes date to a date series! Help!!	Jayjg	Charts and Charting in Excel	2	January 22nd 05 03:00 PM
Date issue between Windows and Macintosh version	dlg1967	Excel Discussion (Misc queries)	4	January 19th 05 03:51 PM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM
adding hours and minutes	Tricia	New Users to Excel	2	November 27th 04 12:29 AM
Using formulas to determine date in one cell based on date in anot	Gary	Excel Worksheet Functions	2	November 22nd 04 08:11 AM

All times are GMT +1. The time now is 07:11 AM.

Menu

About Us