Subtracting a duration from a time to calculate a time.
So now I would like to see if I can take this formula one step further.
I now have it set where the formula is just like you said, but I changed the
format.
Time - Duration = Time
Format is now
10/2/08 7:51 AM 14:01 10/1/08 5:50 PM
Now I would like to add days to the Duration.
like this? 02:14:01 where the format is: dd:[hh]:mm
is that posible? or would I need to calculate (# of days * 24) + [hh]
I don't know if I am being clear.
"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.
|