If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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 |
#2
|
|||
|
|||
Date vs h:mm:ss confusion
Format cell as Time 13:30:55
The cell will show as 7:31:49 The formula bar will show a date as well. Ignore the date. -- Gary's Student "Barry" wrote: 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 |
#3
|
|||
|
|||
Date vs h:mm:ss confusion
Barry
To see how Excel computes dates and times see Chip Pearson's site. http://www.cpearson.com/excel/datetime.htm#AddingTimes Gord Dibben Excel MVP On Mon, 7 Nov 2005 23:47:43 -0000, "Barry" wrote: 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 | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reports with Date Range - Errors | jwr | Setting Up & Running Reports | 12 | August 8th, 2005 12:57 PM |
Revised Date Question | Spectra | Running & Setting Up Queries | 0 | March 18th, 2005 12:19 PM |
Filtering on custom date field | MED | Contacts | 3 | September 17th, 2004 03:05 PM |
Making Excel generate Access-Like Reports | VJ7777 | General Discussion | 15 | September 12th, 2004 05:48 AM |
QDE (Quick Date Entry) | Norman Harker | General Discussion | 3 | September 3rd, 2004 08:00 AM |