| 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? |
| 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 | |||
Threaded Mode
