mattie17uk
New Member
- Joined
- Aug 1, 2002
- Messages
- 13
I hve a wk/sheet which logs what jobs a machine does when and how long the jobs took.
The times for these jobs are in 24hr format.
My problem is when a time goes from one day to the next (machine runs 24hrs a day)
e.g Job start 23:55 job finish 01:55 on the next day.
Whats the best formula to use to get the difference between the two times in minutes.
Thanks in advance for any help.
The times for these jobs are in 24hr format.
My problem is when a time goes from one day to the next (machine runs 24hrs a day)
e.g Job start 23:55 job finish 01:55 on the next day.
Whats the best formula to use to get the difference between the two times in minutes.
Thanks in advance for any help.