Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting time in Excel 2007
I am trying to chart our phone submissions. I get the report from the system
with military time as 10:09:54 and 20:51:58 when a call is received. I need to truncate this time to just the first two left numbers so I can chart by hours. So on my chart all submissions from 1:00:00 to 1:59:00 should chart as 1 for graphing. How do I convert this time to a two digit number in Excel 2007? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting time in Excel 2007
with:
20:14:09 in A1 use the formula: =ROUNDDOWN(A1*24,0) -- Gary''s Student - gsnu200907 "Debbi" wrote: I am trying to chart our phone submissions. I get the report from the system with military time as 10:09:54 and 20:51:58 when a call is received. I need to truncate this time to just the first two left numbers so I can chart by hours. So on my chart all submissions from 1:00:00 to 1:59:00 should chart as 1 for graphing. How do I convert this time to a two digit number in Excel 2007? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting time in Excel 2007
Excel stores time as a fraction of a day
A1 has 1:0:0 B1 has =A1*24 will display 1 when formatted General best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Debbi" wrote in message ... I am trying to chart our phone submissions. I get the report from the system with military time as 10:09:54 and 20:51:58 when a call is received. I need to truncate this time to just the first two left numbers so I can chart by hours. So on my chart all submissions from 1:00:00 to 1:59:00 should chart as 1 for graphing. How do I convert this time to a two digit number in Excel 2007? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formatting time in Excel 2007
Hi,
you may also use =hour(cell_ref) -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Debbi" wrote in message ... I am trying to chart our phone submissions. I get the report from the system with military time as 10:09:54 and 20:51:58 when a call is received. I need to truncate this time to just the first two left numbers so I can chart by hours. So on my chart all submissions from 1:00:00 to 1:59:00 should chart as 1 for graphing. How do I convert this time to a two digit number in Excel 2007? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 calculate time between 2 date/time columns | Excel Discussion (Misc queries) | |||
Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Formatting in Excel 2007 | Excel Discussion (Misc queries) | |||
Formatting in Excel 2007 | New Users to Excel | |||
formatting time in excel | Excel Worksheet Functions |