| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MROUND time
I am using the formula MROUND to get a time hh:mm:ss to the nearest 30seconds.
Cell T2 shows 00:11:24 and U2 shows 30. I have fomated cell T2 and the cell I want the answer in as hh:mm:ss. However the answer cell shows 11:30:00. this seems to be taking the MM and showing as HH and ss as MM. =TIME(MINUTE(T3),MROUND(SECOND(T3),U3),0) is the formula and the cell is formatted hh:mm:ss Can anyone help me to rectify this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MROUND | Excel Worksheet Functions | |||
| MROUND | Excel Discussion (Misc queries) | |||
| MROUND | Excel Discussion (Misc queries) | |||
| MROUND(F2,TIME(0,0,5)) | Excel Discussion (Misc queries) | |||
| Mround | Excel Discussion (Misc queries) | |||
Threaded Mode
