Excel time formula

  VNAM75 09:43 16 Feb 2007

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 2007

I have just found the answer:


  Rtus 10:06 16 Feb 2007

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 2007


would do the same thing.

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

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?