I need a formula that will change 5:27 5 hours and 27 minutes into 5.45 hours.,..?
extract minutes from timestamp as an integer value
percentage = minutes / 60
round percentage to 2 digits
place hour and rounded percentage into proper format for final result
How To Ask FAQ | How To Be A Hacker | Hacker Mindset | jQuery
Dev Shed Forums
© 2003 - 2014 by Devshed, LLC. All rights reserved