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

Huawei MateBook X Pro review

How Pentagram and other design agencies aim to double the number of creative female leaders

How to speed up a slow Mac

Comment résoudre des problèmes d’impressions ?