View Single Post
  #1   Report Post  
k f h
 
Posts: n/a
Default IF statement for hours/mins

Hi All,

I've been given an exercise requiring an IF function, to show if a cell is
greater than 59 to show it as hours and mins. so 61 would be one hour one
min. I know the easy way is to format the cells to time, but thats not the
exercise.

Thanks,

kfh.