| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I create this formula?
Or, even better, use the DATEDIF function
http://www.dataschenk.com/Newsletter...ExDateDif2.htm wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula by joining text and the value from a formula | Excel Worksheet Functions | |||
| Create formula | Excel Worksheet Functions | |||
| How do I create a formula by percentage within a formula? | Excel Worksheet Functions | |||
| How do a create a formula that if a1=rh than c1=13 | Excel Worksheet Functions | |||
| need to create a formula to create a timesheet but haven't a clue | Excel Discussion (Misc queries) | |||
Hybrid Mode
