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.
I have just found the answer:=Hour(A1)
may I suggest > perhaps posting the whole formula entry may help others that have been trying this out & got nowhere ? thanks VNAM75
=TEXT(A1,"h")would do the same thing.
This thread is now locked and can not be replied to.
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?
© Copyright 2017 IDG UK. All Rights Reserved.