Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
hi all. I've got the following situation: I have a column with operations and
a next one containg the time they occured (time format 00:00:00), what I want is to determine a standart time interval for every occurence, eg: 08:15:12 should result 08:00 - 09:00 and so on, with 1 hour steps. I now I should create a function and use the select statement but have no clue how to do send the tim to the vba, process it and send it back to the cell. any help will be much appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there an XLS function to convert std time to Military time? | Excel Worksheet Functions | |||
Macro / function text time to 24hr excel time passed midnight fortotaling hr's | Excel Worksheet Functions | |||
verify use of TIME Function, Find Quantity Level compare to time-d | Excel Discussion (Misc queries) | |||
Function Call Specified at Run Time rather than Compile Time? | Excel Programming | |||
Function to convert Time String to Time | Excel Worksheet Functions |