GHR_GDL
asked on
How to calculate elapsed time on Excel at command
Hi, I have these columns in my excel spreadsheet:
A = system date
B = random date
C = elapsed days (system date - random date, where random date <= system date)
How can I recalculate column C at command? I mean, if for example there were a button for that, I would like to push it and refresh column C, always getting tha actual system date and substracting the date especified in column B; is there some simple way to implement that functionality in Excel? (using buttons was only a illustration, I only care about the functionality). I only know the very basics of using a spreadsheet, I would like a little help with this issue. I'm using Excel 2007.
Thanks in advance.
A = system date
B = random date
C = elapsed days (system date - random date, where random date <= system date)
How can I recalculate column C at command? I mean, if for example there were a button for that, I would like to push it and refresh column C, always getting tha actual system date and substracting the date especified in column B; is there some simple way to implement that functionality in Excel? (using buttons was only a illustration, I only care about the functionality). I only know the very basics of using a spreadsheet, I would like a little help with this issue. I'm using Excel 2007.
Thanks in advance.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Shouldn't the formula at C just be this?
Sample In C2: =TODAY()-B2
Sample In C2: =TODAY()-B2
ASKER
Those shortcuts were very useful, thanks!
hit F9 and the formulas will recalculate.
cheers, teylyn