Thursday 26 October 2017

Microsoft Excel - format cell so it shows nothing instead of 00:00:00

Watch this example on YouTube



[>=1] d"d" hh:mm:ss; [>0] hh:mm:ss;
Posted by at

3 comments:

  1. GG4 June 2020 at 10:16

    I want to record a macro to automatically select cells that contain times such as: 2 days 00:03:34 or 1 days 23:56:22 and change them to all hours and remove the days.

    ReplyDelete
  2. Xavier30 July 2022 at 15:08

    Nice, and very helpfull: Thank you!

    ReplyDelete

Subscribe to: Post Comments (Atom)