A Alan T Feb 10, 2004 #1 Is it possible to display only the hour element of a time. i.e. 14.05:32PM displays as 14.00 or something simila
Is it possible to display only the hour element of a time. i.e. 14.05:32PM displays as 14.00 or something simila
N Niek Otten Feb 10, 2004 #2 Format>Cells>Custom. In the Type box, enter -- Kind Regards, Niek Otten Microsoft MVP - Excel hh
F Frank Kabel Feb 10, 2004 #3 Hi format the cell with the custom format hh:"00" Frank Is it possible to display only the hour element of a time. i.e. 14.05:32PM displays as 14.00 or something similar Click to expand... Hi format the cell with the custom format hh Frank
Hi format the cell with the custom format hh:"00" Frank Is it possible to display only the hour element of a time. i.e. 14.05:32PM displays as 14.00 or something similar Click to expand... Hi format the cell with the custom format hh Frank
N Niek Otten Feb 10, 2004 #4 Sorry! Last edit deleted the hh. See Franks answer. -- Kind Regards, Niek Otten Microsoft MVP - Excel Niek Otten said: Format>Cells>Custom. In the Type box, enter -- Kind Regards, Niek Otten Microsoft MVP - Excel hh Click to expand...
Sorry! Last edit deleted the hh. See Franks answer. -- Kind Regards, Niek Otten Microsoft MVP - Excel Niek Otten said: Format>Cells>Custom. In the Type box, enter -- Kind Regards, Niek Otten Microsoft MVP - Excel hh Click to expand...
