| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show a time 50 min before entered time
Right click sheet tabview codecopy/paste this
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address < "$D$2" Then Exit Sub x = Left(Target, 2) & ":" & Right(Target, 2) 'MsgBox x Application.EnableEvents = False Target.Value = TimeValue(x) - (50 / 1440) Application.EnableEvents = True End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "cristo" wrote in message ... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can I add time that I entered in only minutes and seconds | Excel Discussion (Misc queries) | |||
| Show time stamp when a value is entered | Excel Discussion (Misc queries) | |||
| Time Card Show Up Time | Excel Worksheet Functions | |||
| Show timesheet time in and out in regular time versus military tim | Excel Worksheet Functions | |||
| I need a time sheet template that verifies time entered against sy | Excel Discussion (Misc queries) | |||
Threaded Mode
