| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Show a time 50 min before entered time
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
