| 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 | |||
Linear Mode
