Ok i'm wondering if this is possible. I'm trying to make a formula that will convert time into a decimal. This is used for keeping track of hours. Example: Billy bob joe signed in from 2:12 to 3:00. so for me to track the hours i have to round to the nearest 1/4 which makes 2:15 to 4:00. which would give them 1.75 hours for that day. is there anyway for excel to do this for me. Hope this makes sense, and as always thank you for your time guys.