PPRuNe Forums - View Single Post - Excel time function help please
View Single Post
Old 30th Aug 2007, 22:48
  #3 (permalink)  
bnt
 
Join Date: Feb 2007
Location: Dublin, Ireland. (No, I just live here.)
Posts: 733
Received 7 Likes on 6 Posts
There is the TIMEVALUE function, that takes a string and converts it into a time. I just tried it, it seems to handle "hh:mm" OK.
It returns a standard Excel date/time value, where 1 = 1 day. So you can multiply the result by 24 to get hours, or 86400 to get seconds.
bnt is offline