Thread: Format cells to minutes and seconds
View Single Post
 
Old 09-23-2019, 01:23 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Another possible solution.


NB! I used the format [m]:ss, which allows minutes over 60 sec. displayed. And replaced PdfTime for last row from 2:25 to 52:25 to get sum > 60 minutes as example.
Attached Files
File Type: xlsx List 1 - Copy.xlsx (11.7 KB, 15 views)
Last edited by ArviLaanemets; 09-23-2019 at 04:54 AM.
Reply With Quote