Time difference calculations

Copper Contributor

I'm working on a detention tracker for my drivers. I need it to tell me how many hours they waited in door minus 4 hours and another column to take the hours in door times $100.00 per hour.

 

example:

1/19/2023 9:301/19/2023 16:303 Hours$300.00
2 Replies

@JanaDunk Best explained by a working example. See attached.

 

Screenshot 2023-01-21 at 07.08.24.png

@Riny_van_Eekelen 

 

thank you so much. I knew I was making it harder than it was.