Minutes/seconds not right ( 24 ??? %$@#$%$)
You're welcome.
Pete
On Jul 11, 6:28*pm, Steve wrote:
Thanks guys,
much appreciated.
"Pete_UK" wrote:
If you have in B1:
=A1/60
and in C1:
=B1/60
then C1 represents hours. To get this into Excel time format you must
divide by a further 24:
=C1/24
then you can format this cell as [mm]:ss to ensure that the minutes
don't wrap around if they exceed 60.
Hope this helps.
Pete
|