Use the following worksheet event macro:

Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("D2")
If Intersect(Target, r) Is Nothing Then Exit Sub
Application.EnableEvents = False
r.Value = r.Value - 0.03472222222
Application.EnableEvents = True
End Sub

If you enter 7:00 in the cell, is will display 6:10
--
Gary''s Student - gsnu200754


"cristo" wrote:

I want to enter a time in cell d2 and I want cell d2 to show 50 minutes
earlier. What formula can I use.
At present when I format the cells as Hrs & mins when I enter 0700 the time
returns as 00:00

Regards jcs