The Animal
Active Member
- Joined
- May 26, 2011
- Messages
- 449
Hi
I have cells J2 (start time) and K2 (finish time)
I need to calculate the time elapsed between the two cell values in hours and minutes but some will be start AM and finishing AM but some will be starting AM but finishing PM.
The format of the start/finish is h:mm AM/PM
Any help would be great
Stephen
I have cells J2 (start time) and K2 (finish time)
I need to calculate the time elapsed between the two cell values in hours and minutes but some will be start AM and finishing AM but some will be starting AM but finishing PM.
The format of the start/finish is h:mm AM/PM
Any help would be great
Stephen