Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date vs h:mm:ss confusion
I have a table of approx 120 cells which contain what is supposed to be a
number of hours:mins:secs but in the formula bar a date and time is shown. Example - cell shows 15:31:49. Formula is shown as 06/01/1900 07:31:49 . Cells are formatted as custom (h):mm:ss and copy/paste-special - value throws up the result 6.31376157407407 The data forms part of an exercise to graphically illustrate the number of minutes different departments spent on the phone each month using the billing spreadsheets supplied by the telephone company and I need to convert what is in each cell to a meaningful figure which can then be shown on a graph. Can anyone help? Thanks Barry |
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 | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions |