Excel date/time format as days hh:mm and suppress 0 days

September 27, 2012 at 04:58:29
Specs: Windows XP
date/time format using d hh:mm How to suppress 0 days?

See More: Excel date/time format as days hh:mm and suppress 0 days

Report •


#1
September 27, 2012 at 06:51:06
As far as I can tell, there is no way to suppress the Zero using that Custom Format.

You could probably process the data and remove the Zero but you will need either a formula or VBA.

Is this the result of a calculation?

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question