PPRuNe Forums - View Single Post - Excel time function help please
View Single Post
Old 30th August 2007 | 22:48
  #3 (permalink)  
bnt
15 Anniversary
 
Joined: Feb 2007
Posts: 755
Likes: 26
From: Dublin, Ireland. (No, I just live here.)
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  
Reply