Posted to microsoft.public.excel.worksheet.functions

vezerid

external usenet poster

Posts: 751

Calculate duration day +1

On May 23, 4:28 pm, Marc S. wrote:
How can I define the end of the next starting from a cell content dd/mm/yyyy
hh:mm
for exemple
Start time 15/05/2007 08:20
I need to define the value of the day +1 meaning 16/05/2007 24:00

Thanks you
Marc

=CEILING(A1,1)

HTH
Kostis Vezerides

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
How do I calculate duration between two dates and times in excel?	Robin CSM002	Excel Discussion (Misc queries)	3	May 13th 23 07:42 PM
Calculate duration day +1	vezerid	Excel Worksheet Functions	1	May 23rd 07 07:29 PM
Calculate duration day +1	Marc S.	Excel Worksheet Functions	2	May 23rd 07 03:27 PM
Calculate duration in Excel 2000	Babette	Excel Worksheet Functions	1	November 22nd 05 11:21 PM
Calculate Duration.	Art	Excel Discussion (Misc queries)	6	September 5th 05 01:03 AM

All times are GMT +1. The time now is 09:23 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us