Time Calculations, Formula and Formats

[kwvh]

This may have been asked and answered, but i can"t find it
Column A has "Goal" (number of minutes formatted as a number)
Column B has a "Start Time" (formatted as military time)
Column C has "End Time" (formatted as military time)
Column D has "Elapsed Time"
Column E is the difference between the Elapsed Time (Column D) and the Goal (column A).

Any ideas on how to accomplish this?

Thank you for your consideration.

Respectfully,

Ken

[HansV]

By military time, do you mean (for example) 1320, or 13:20 ?

[HansV]

If military time is for example 1320:

In D2:

=60*INT(C2/100)+MOD(C2,100)-60*INT(B2/100)-MOD(B2,100)

If B2 could be before midnight and C2 after midnight:

=60*INT(C2/100)+MOD(C2,100)-60*INT(B2/100)-MOD(B2,100)+1440*(C2<B2)

In E2:

=D2-A2

[HansV]

If military time is for example 13:20:

In D2:

=1440*(C2-B2)

Format D2 as a number. If B2 could be before midnight and C2 after midnight:

=1440*(C2-B2+(C2<B2))

In E2:

=D2-A2

[kwvh]

Hans,

Sorry, Military for me is 13:32

[kwvh]

Oops, you responded with solutions for both.

Thank you Hans!

[HansV]

An alternative formula for D2 is

=1440*MOD(C2-B2,1)

Again, format D2 as a number.