A
Alan T
Is it possible to display only the hour element of a time.
i.e. 14.05:32PM displays as 14.00 or something simila
i.e. 14.05:32PM displays as 14.00 or something simila
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
Niek Otten
Format>Cells>Custom. In the Type box, enter
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
hh
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
hh
F
Frank Kabel
Hi
format the cell with the custom format hh:"00"
Frank
Hi
format the cell with the custom format hh
Frank
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
Hi
format the cell with the custom format hh
Frank
N
Niek Otten
Sorry! Last edit deleted the hh. See Franks answer.
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
--
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