Posted to microsoft.public.excel.programming

Stephen[_24_] Stephen[_24_] is offline

external usenet poster

Posts: 83

furmula to add hours

I have a cell (B3) that is a date formatted as 01/01/08 0:00:00
I want a formula in another cell (D3) that takes the value of B3 and adds
time to it.

eg.

B3 - 01/01/08 00:00:00
D3 - 01/01/08 23:59:59

??

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
Conditional Formating Furmula	jockj215	Excel Discussion (Misc queries)	3	December 4th 09 12:36 PM
I want to get a furmula for get a percentage	Bassil	Excel Worksheet Functions	1	June 29th 08 06:08 PM
Need furmula of R-squared by polynomial regression	Xiaoyoy Yun	Excel Programming	2	November 21st 07 08:45 PM
Desperately needing furmula help	Fred Djinn Holstings	Excel Discussion (Misc queries)	11	February 2nd 07 07:46 PM
Issue creating a furmula in VBA, Please Help	mikeb	Excel Programming	3	November 6th 06 06:33 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us