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?