Is there a formula that will calculate the amount of time from a start point till current day.
Example: I want to enter a start date and time, and in another cell I want the amount of time that has elapsed between the start date and time till the current date and time, something like: 90 day, 6 hours, and 23 minutes or even 180 hours and 23 minutes or maybe just 180 hours would do.
Hi slick,
Assuming Start Date in A1 and Start Time in A2, use
=NOW()-(A1+A2)
and custom format the cell as
[h]:mm
how should the cell A1 and A2 be formatted or does it matter?
If you are entering the data in the form of a date and a time, i.e., 9/23/04 and 16:22, Excel should recognize it as such. If you are importing the data, though, you should probably format the cells beforehand with any of the standard date and time formats.
FYI, Excel will recognize a one cell date and time, such as 9/23/04 16:22 entered in cell A1. You could then simplify your formula to =Now()-A1.
Dangelor this is the formula I'm using =NOW()-(F4)
F4 contains my startdate/time 9/10/2004 8:00 AM
Results: the formula seems to calculate the time elapsed from 8:00 but not from 8:00 on the 10th, it calculate the elapsed time from 8:00 of each day.
Slick,
Make sure the cell with the formula is formatted with [h]:mm
Thanks dangelor, that did the trick
Dangelor, I did some playing around with the formatting and tried this and it accomplished exactly what I needed custom format: dd hh:mm:ss
actually what I did was use your formula in two cells one to calculate the # of days and the other to calculate hours, minutes, and seconds.
Thanks again, you were a big help
Glad I was able to help.
Don’t have an account yet? Register yourself now and be a part of our community!
