Time between 2 dates and times

Thanks Paul, It appears to work as you said. However thinking this through a bit more since I dont know for sure what hours they will be working each day I decided to loop through the range and add up all the working minutes they work.

The problem I have now is I am returning the number of minutes but I want to place how many hours and minutes back into the cell as hh:mm.

I'm trying this after I get the minutes total(myresults) in this case its 2971 minutes which is 49 hours and 31 minutes

Please Login or Register  to view this content.

Now I want to place 49:31 back in the cell, This is the part that isnt working not sure which method is correct to use or if both are wrong because it appears results is a text value "49:31" and not a time value, but when I change the format of the cell it becomes 01:31

Can someone advise which is the corret method or another method?

Thank You, Mike

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Here is how it's layed out in the script which seems to work till I change the format of the cell?

Please Login or Register  to view this content.

Oh Good Grief...my bad...

Thanks for pointing that out.

Mike