How do I convert 8:30 to 8.5 hours?
I am trying to create a scheduler and need to find out the hours worked in a
given day. For example, I worked from 9:00 AM to 5:30 PM with an hour break.
I would like to return a value of 8.5 hours minus 1 hour equals 7.5 hours.
Thanks.
|