Advertisement
Guest User

Untitled

a guest
Oct 9th, 2015
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  1. =(B$15*B22%)*TIMEVALUE("00:01:00")
  2.  
  3. $B15 = 37;
  4. $B22=100;
  5.  
  6. $temp_time = strtotime('00:00:00');
  7. $time_value = strtotime('00:01:00');
  8. $time_data = ($time_value - ($temp_time)) / 86400;
  9.  
  10. $t = ($B15*($B22/100)) * $time_data;
  11.  
  12. date_default_timezone_set('UTC');
  13. date("h:i:s",strtotime($t));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement