| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date formats
I have a cell that works out how many days someone has worked in my company
for. However, I'm trying to change the format of that cell so rather than it saying, for example 743 as days, I want it to show as years, months, days i.e 2:01:15 Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
| Calculate 1st of month date from existing date. | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Date formats | Excel Discussion (Misc queries) | |||
Threaded Mode
