Time calculations

Normie · #1 12-10-2015, 09:38 AM

I am looking to add up time on job that crosses over midnight (shift is 20:00 - 04:30) I can format for same day times but cannot figure out the cross over times

can someone help please

Kevin@Radstock · #2 12-10-2015, 10:01 AM

Hi

Assuming that the start time is in A1 and end time in B1:

=MOD(B1-A1,1) and format as "hh:mm" without the quotes.

Normie · #3 12-10-2015, 11:13 AM

Success!!! thank you for your help

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculations	etobias	Word	4	12-03-2015 01:36 PM
Form Driven Date/Time Calculations	dnunnally	Word VBA	3	08-27-2015 09:56 AM
Real Time calculations	wgutshall	Excel	3	07-10-2015 08:44 AM
Tiered Fee Calculations	lynchbro	Excel	5	07-17-2014 11:01 AM
Can I do calculations with times?	cubsfan_1	Excel	1	01-14-2010 06:55 PM