Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desperate for help with these formats
The below are values in seconds and milliseconds.
28.921 36.432 If excel adds these values I get 65.353 If I change the format to mm:ss.000 I get 28:19.200 I need to get 1:05.353. (ie 1 min and 5 secs etc) as these cells are used in a formula. Does anyoe have any suggestions as I am stuck on my sheet until I solve this. Ps. I looked at len and tried some code that if the len < 6 then the value was "00:" & cell.value but this didn't work - possibly due to my code - but I was getting a decimal number in the cell. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Desperate for help with these formats
convert the times to days so the formula would be
=SUM(A1:A2)/86400 assuming your values are in cells A1 and A2 then apply your formatting "keri" wrote in message ups.com... : The below are values in seconds and milliseconds. : : 28.921 : 36.432 : : If excel adds these values I get 65.353 If I change the format to : mm:ss.000 I get 28:19.200 : : I need to get 1:05.353. (ie 1 min and 5 secs etc) as these cells are : used in a formula. Does anyoe have any suggestions as I am stuck on my : sheet until I solve this. : : Ps. I looked at len and tried some code that if the len < 6 then the : value was "00:" & cell.value but this didn't work - possibly due to my : code - but I was getting a decimal number in the cell. : |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
STILL DESPERATE FOR HELP!!! | Excel Discussion (Misc queries) | |||
DESPERATE FOR HELP!!! | Excel Discussion (Misc queries) | |||
Desperate | Excel Discussion (Misc queries) | |||
Desperate...please help! | Excel Worksheet Functions | |||
In desperate need of help.... | Excel Discussion (Misc queries) |