Excel time formula

  VNAM75 09:43 16 Feb 07
Locked

I have a column of cells in the format hh/mm/ss and want a formula to return the hour.

eg. For 08:30:00 it returns 8.

  VNAM75 09:50 16 Feb 07

I have just found the answer:

=Hour(A1)

  Rtus 10:06 16 Feb 07

may I suggest > perhaps posting the whole formula entry may help others that have been trying this out & got nowhere ? thanks VNAM75

  VoG II 10:30 16 Feb 07

=TEXT(A1,"h")

would do the same thing.

This thread is now locked and can not be replied to.

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…