I'm getting an error (#Value) when attempting to extract minutes from the largest number (Monthly Hours/Mins/Sec) and would appreciate some advice.
e.g. 10974:36:26 which I wanted to extract 36 out to perform some calculation. MINUTE formula will not works. Thanks.
Please see the attached file for a sample.
e.g. 10974:36:26 which I wanted to extract 36 out to perform some calculation. MINUTE formula will not works. Thanks.
Please see the attached file for a sample.
Attachments
Last edited: