Posted to microsoft.public.excel.worksheet.functions

Eric

external usenet poster

Posts: 1,670

counting periods Excel

Hello,

I have a problem with counting periods in Excel. When I try to count
(A1) 7-5-2007 8:00 and (B1) 10-06-07 8:00 the result is a period of
3:0:00 (dd:hr:min)
(formula: B1-A1) and
34:00:00 (dd:hr:min)
(formula: =INTEGER(B1-A1)&":"&TEKST(B1-A1;"uu:mm" )

Excel doesn't count over a month.

Any solutions for my problem?

Thanks

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
Excel 2002, MS Query and MSSQL View with periods	John T in MD	Excel Discussion (Misc queries)	0	March 14th 07 02:06 PM
periods of time	Ben	New Users to Excel	1	March 5th 06 07:47 PM
Counting consecutive periods	self_made1	Excel Worksheet Functions	1	December 21st 05 05:44 PM
13 periods	Steved	Charts and Charting in Excel	1	August 11th 05 05:22 AM
File-Save is grayed out for periods of time in Excel 2003	Ned Grubb	Excel Discussion (Misc queries)	1	June 14th 05 09:47 PM

All times are GMT +1. The time now is 07:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us