Thread: how do u turn time into a number
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
  
Posts: 896
Default how do u turn time into a number
sorry, my fault
2 also needs to be converted to number
thus 2 will equal 0.833333333

=INT(p7/0.833333333)*5
Reply With QuoteReply With Quote