Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding time
A1 to A200 are starting time.
B1 to B200 are finishing time. C1 to C200 formula is : =(B1-A1)*24*60 Copied down. Giving me minutes difference between B and A. When I have A1= 8A and B1=8:25a I get of course 25 minutes. In order to do my work I need those 25 minutes rounded to 30, as I only use 30, 60, 90, 120, 150...( half hour, one hour, hour and a half, two hr...) I think I need to change the whole formula but I have not clue about it, in order to do the rounding time. Do I need a helper column or just different formula? Thanks for your help. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding time
=MROUND((B1-A1)*24*60,30)
"Learning Excel" wrote: A1 to A200 are starting time. B1 to B200 are finishing time. C1 to C200 formula is : =(B1-A1)*24*60 Copied down. Giving me minutes difference between B and A. When I have A1= 8A and B1=8:25a I get of course 25 minutes. In order to do my work I need those 25 minutes rounded to 30, as I only use 30, 60, 90, 120, 150...( half hour, one hour, hour and a half, two hr...) I think I need to change the whole formula but I have not clue about it, in order to do the rounding time. Do I need a helper column or just different formula? Thanks for your help. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding time
Got to give it to you Teethless mama, it works perfect.
Now I know, the more I know, the less I know. I don't know. THANKS ! -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. "Teethless mama" wrote: =MROUND((B1-A1)*24*60,30) "Learning Excel" wrote: A1 to A200 are starting time. B1 to B200 are finishing time. C1 to C200 formula is : =(B1-A1)*24*60 Copied down. Giving me minutes difference between B and A. When I have A1= 8A and B1=8:25a I get of course 25 minutes. In order to do my work I need those 25 minutes rounded to 30, as I only use 30, 60, 90, 120, 150...( half hour, one hour, hour and a half, two hr...) I think I need to change the whole formula but I have not clue about it, in order to do the rounding time. Do I need a helper column or just different formula? Thanks for your help. -- Socrates said: I only know, I don''''t know nothing. I say : I don''''t even know, I don''''t know nothing. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rounding time | Excel Worksheet Functions | |||
Rounding Time? | Excel Worksheet Functions | |||
Time rounding help | Excel Discussion (Misc queries) | |||
Rounding Time? | Charts and Charting in Excel | |||
Rounding off TIME | Excel Discussion (Misc queries) |