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 |
#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 |
Reply |
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 |