Formatting time in Excel 2007

[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?

 

[Gary''s Student]

with:
20:14:09
in A1 use the formula:
=ROUNDDOWN(A1*24,0)

 

[Bernard Liengme]

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

 

[Ashish Mathur]

Hi,

you may also use

=hour(cell_ref)

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com