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
|