Removing minutes from hours:minutes in Excel
 

I am trying to track the number of online transactions throughout the day by
hour. I have exported from a database a field that shows date and time
together in each cell. I have figured out how to separate date and time into
separate columns. But I want to convert all the hours:minutes into the hour
only, for instance 6:01, 6:17, and 6:20 should all become 6:00. I have tried
doing ROUNDDOWN, but this simply rounds down to various hours and minutes,
depending on how many "decimals" I say to retain. TRUNCATE likewise does not
work. The new value needs to be exactly at the hour so that all transactions
during 6:00-6:59 show 6:00 as the underlying value. How do I do this

Removing minutes from hours:minutes in Excel
 

Try

=HOUR(A1)

Mike

"wpc09" wrote:

I am trying to track the number of online transactions throughout the day by
hour. I have exported from a database a field that shows date and time
together in each cell. I have figured out how to separate date and time into
separate columns. But I want to convert all the hours:minutes into the hour
only, for instance 6:01, 6:17, and 6:20 should all become 6:00. I have tried
doing ROUNDDOWN, but this simply rounds down to various hours and minutes,
depending on how many "decimals" I say to retain. TRUNCATE likewise does not
work. The new value needs to be exactly at the hour so that all transactions
during 6:00-6:59 show 6:00 as the underlying value. How do I do this

Removing minutes from hours:minutes in Excel
 

One way:

=FLOOR(A1,TIME(1,0,0))


In article ,
wpc09 wrote:

I am trying to track the number of online transactions throughout the day by
hour. I have exported from a database a field that shows date and time
together in each cell. I have figured out how to separate date and time into
separate columns. But I want to convert all the hours:minutes into the hour
only, for instance 6:01, 6:17, and 6:20 should all become 6:00. I have tried
doing ROUNDDOWN, but this simply rounds down to various hours and minutes,
depending on how many "decimals" I say to retain. TRUNCATE likewise does not
work. The new value needs to be exactly at the hour so that all transactions
during 6:00-6:59 show 6:00 as the underlying value. How do I do this