| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Current Date when cell is empty??
HI
Apologies for this - I just seem to have left my brain at home today. Essentially I'm calculating the time difference in hours between IssueLogged and IssueClosed - this bit I have solved ... =int(IssueClosed-IssueLogged)*24) ...., but the second part I need is if IssueClosed is empty, get Excel use the current date and use this to show how long it has been since the Issue was logged. any/all help appreciated! D |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert Current Date when cell is empty??
One way:
=INT((MIN(IssueClosed,NOW()) - IssueLogged)*24) In article , Dazed&confused! wrote: HI Apologies for this - I just seem to have left my brain at home today. Essentially I'm calculating the time difference in hours between IssueLogged and IssueClosed - this bit I have solved ... =int(IssueClosed-IssueLogged)*24) ...., but the second part I need is if IssueClosed is empty, get Excel use the current date and use this to show how long it has been since the Issue was logged. any/all help appreciated! D |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert Current Date when cell is empty??
Thanks for this - it didn't quiet work tho. I put in date of 05/01/2007
07:00 (5th Jan 07, 7am) and left the IssueClosed cell empty and the formula came back with value of 51. I checked formatting of the columns etc and can't see anything wrong with them. The formula returned the expected result when I put in a date to the IssueClosed cell. Should I force an entry into the IssueClosed cell of 0?? "JE McGimpsey" wrote: One way: =INT((MIN(IssueClosed,NOW()) - IssueLogged)*24) In article , Dazed&confused! wrote: HI Apologies for this - I just seem to have left my brain at home today. Essentially I'm calculating the time difference in hours between IssueLogged and IssueClosed - this bit I have solved ... =int(IssueClosed-IssueLogged)*24) ...., but the second part I need is if IssueClosed is empty, get Excel use the current date and use this to show how long it has been since the Issue was logged. any/all help appreciated! D |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert Current Date when cell is empty??
Check the formula again. When I put 5 Jan 2007 07:00 in IssueLogged and
leave IssueClosed blank, the formula returns 775, which is correct. In article , Dazed&confused! wrote: Thanks for this - it didn't quiet work tho. I put in date of 05/01/2007 07:00 (5th Jan 07, 7am) and left the IssueClosed cell empty and the formula came back with value of 51. I checked formatting of the columns etc and can't see anything wrong with them. The formula returned the expected result when I put in a date to the IssueClosed cell. Should I force an entry into the IssueClosed cell of 0?? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Insert Current Date when cell is empty??
Thanks JE - I had some old formula lurking in that cell.
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Click a cell and update to current time / date ? | Excel Discussion (Misc queries) | |||
| How can I check a cell for current date and insert it if blank? | New Users to Excel | |||
| Empty Date Cell as Zero | Excel Discussion (Misc queries) | |||
| Mileage Claim Formula | New Users to Excel | |||
| why a reference to an empty cell is not considered empty | Excel Discussion (Misc queries) | |||
Linear Mode
