How can I create this formula?

S

sultann

Unless I'm missing something...

Change Cells B4, C4 and B6 to "Date" format of "MM.DD.YY HH:MM"
Change Cell C4 from "=TODAY()" to "=NOW()"

Expand B6 so that it all fits.

When I do this, I get the following result: "1.31.00 8:05"

The subtraction doesn't seem to quite work properly, so you might have
to separate out months/days/hours/seconds into different calculations
and re-combine. Excel is calculating the months, days, hours, and
seconds separately.

(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top