EXCEL 2003 Dates & elapsed time
 

Elegant formula help needed. the 4 cells concerned a

Date received, Date Claimed, storage start date and Elapsed days. Whe if
the goods are claimed in less than 24 hours NO elapsed days and no storage
date show. If than 1 day then storage date starts as Date Received +1and
elapsed days begin. Storage chard=ges are driven by elapsed time.

This formula of mine doesn't work and is to clumsy anyway.
=IF(K5-J5<=1,"",IF(K5-J51,J5+1))

Many thanks

EXCEL 2003 Dates & elapsed time
 

One way:

If you're only entering dates:

Storage Start Date:

L5: =IF(J5=K5,"",J5+1)

Elapsed Days:

M5: =IF(L5="","",TODAY()-L5)

If you're actually entering dates and times in J5 & K5, then

L5: =IF(K5-J5<=1,"",J5+1)
M5: =IF(L5="","",INT(NOW()-L5))


In article ,
Michell Major wrote:

Elegant formula help needed. the 4 cells concerned a

Date received, Date Claimed, storage start date and Elapsed days. Whe if
the goods are claimed in less than 24 hours NO elapsed days and no storage
date show. If than 1 day then storage date starts as Date Received +1and
elapsed days begin. Storage chard=ges are driven by elapsed time.

This formula of mine doesn't work and is to clumsy anyway.
=IF(K5-J5<=1,"",IF(K5-J51,J5+1))

Many thanks

EXCEL 2003 Dates & elapsed time
 

If the dates are DATES only (no times) then try this:

in L5:

=IF(K5-J5<=1,"",J5+1)

Elapsed days: (in M5)

=IF(L5<"",TODAY()-L5+1,"")

J2=07/04/2007 (UK dates)
K2=12/04/2007
L2=08/04/2007
M2=4 (today is 11/04/2007)

HTH


"Michell Major" wrote:

Elegant formula help needed. the 4 cells concerned a

Date received, Date Claimed, storage start date and Elapsed days. Whe if
the goods are claimed in less than 24 hours NO elapsed days and no storage
date show. If than 1 day then storage date starts as Date Received +1and
elapsed days begin. Storage chard=ges are driven by elapsed time.

This formula of mine doesn't work and is to clumsy anyway.
=IF(K5-J5<=1,"",IF(K5-J51,J5+1))

Many thanks

EXCEL 2003 Dates & elapsed time
 

Many thanks. I have since found that I need to 'stop the clock' when a
claimed date (L2) is entered. M2 continues to tot-up elapsed days?

TIA

Dan

"Toppers" wrote:

If the dates are DATES only (no times) then try this:

in L5:

=IF(K5-J5<=1,"",J5+1)

Elapsed days: (in M5)

=IF(L5<"",TODAY()-L5+1,"")

J2=07/04/2007 (UK dates)
K2=12/04/2007
L2=08/04/2007
M2=4 (today is 11/04/2007)

HTH


"Michell Major" wrote:

Elegant formula help needed. the 4 cells concerned a

Date received, Date Claimed, storage start date and Elapsed days. Whe if
the goods are claimed in less than 24 hours NO elapsed days and no storage
date show. If than 1 day then storage date starts as Date Received +1and
elapsed days begin. Storage chard=ges are driven by elapsed time.

This formula of mine doesn't work and is to clumsy anyway.
=IF(K5-J5<=1,"",IF(K5-J51,J5+1))

Many thanks