scamsel
New Member
 Joined
 Apr 2, 2007
 Messages
 33
 Office Version

 365
 Platform

 Windows
hi, anyone know a simple way, where if i have a cell that can have either a positive or negative number of hours (formatted as custom h:mm), i could convert that to an equivalent decimal form of hours such as:
Get 8:30. need to convert to 8.5 hours.
Get 7:00. need to convert to 7 hours.
etc
thank you!
Get 8:30. need to convert to 8.5 hours.
Get 7:00. need to convert to 7 hours.
etc
thank you!