Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting total minutes into hours and minutes in Excel | Excel Worksheet Functions | |||
converting Days Hours & minutes into just minutes in excel | Excel Discussion (Misc queries) | |||
how to change a decimal number (minutes) into hours and minutes? | Excel Discussion (Misc queries) | |||
Convert a number of minutes like 400 into hours and minutes | Excel Worksheet Functions | |||
add column of minutes, show total in hours & minutes | Excel Worksheet Functions |