Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert to minutes and seconds
Code (as follows) calculates, and places a value in a cell.
The value is in Minutes, and rounded to 2 decimal places: With C .Value = (Range("A" & C.Row).Value * 60) _ / (Cells(3, C.Column).Value / 60) .Value = Round(C.Value, 2) End With I cannot find a way to display the value in "mm:ss" format .....preferably also the seconds to 2 decimal places. Is this possible, please? Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text entered as minutes/seconds to minutes | Excel Worksheet Functions | |||
Need to convert Minutes:Seconds format to minutes with seconds con | Excel Worksheet Functions | |||
I need to convert 157.25 minutes, into hours, minutes and seconds. | Excel Discussion (Misc queries) | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Convert seconds to minutes and seconds in excel | Excel Worksheet Functions |