Need to calculate the time worked sometimes between 2 days, and it is military time in 100 minutes. Examples:
In
5/19/09 06:00 (which is 6:00 am)
Out
5/19/09 16:50 (which is 4:30 pm)
In
5/19/09 18:10 (which is 6:07 pm)
Out
5/20/09 06:25 (which is 6:15 am)
Then I want to take out .50 (or 30 minutes) for lunch period as well.
I've tried multiple formulas and searched, and can't get it to work. Any ideas?
In
5/19/09 06:00 (which is 6:00 am)
Out
5/19/09 16:50 (which is 4:30 pm)
In
5/19/09 18:10 (which is 6:07 pm)
Out
5/20/09 06:25 (which is 6:15 am)
Then I want to take out .50 (or 30 minutes) for lunch period as well.
I've tried multiple formulas and searched, and can't get it to work. Any ideas?