Worked Perfectly! Thanks soo much.

"Bernie Deitrick" wrote:

If they are just times:

=IF(B2A2,A2+1-B2,A2-B2)

If they are date and times formatted for time, then use

=A2-B2

In either case, format for time AM/PM.


HTH,
Bernie
MS Excel MVP


"SRadmin" wrote in message
...
I need a formula that calculates the like this:

Time - Duration = Time

Formated to look like this

8:10 AM 22:17 9:53 AM

where the duration is [hh]:mm (I think)

so I need to know how to format the cells and the formula.