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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

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