what is the formula for calculating integer value of a 24 hr time format. i.e to return 2.75 for the time value of 2:45. I am using this to create a simple time sheet.

time out-time in = time on job Then to multiply that by a rate to return wage

Thanks

Pretty silly of me but hopefully someone else gets value out of this answer.

The value of a date formulated cell is a 24th of a day. So if that value is multiplied by 24 it returns an integer equivalent. 2:45 in C2
Value(c2)*24 will return 2.75 which is in integer form

Have a great day.