Formatting time in Excel 2007

  • Thread starter Thread starter Debbi
  • Start date Start date
D

Debbi

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?
 
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
 
Back
Top