#### TAPS_MikeDion

##### Well-known Member

- Joined
- Aug 14, 2009

- Messages
- 506

- Office Version
- 2011

- Platform
- MacOS

I have been trying without any luck to find the time difference (Sun - Sat, employee start & finish times) between two columns of times, but the finish time may go into the next day. I found a post here that I thought might work, but VBA MOD is apparently different from Excel MOD.

I merely have columns starting as "

**SUN Start Time**", "

**SUN Finish Time**", "

**MON Start Time**", "

**MON Finish Time**", and so on until "

**SAT Finish Time**" and need to find the time difference between each days start and finish in order to combine them and find the total hours worked in a week.

If needed, the columns go from "AO" (col # 41) to "BB" (col # 54)

Thanks to whomever jumps in on this to help!