| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to enter start and end date/time in excel based on some specific value.
Hello,
I want to enter date with no. of hours spent - start date/time and end date/time in excel based on some value. Say, I have three cells in Excel. value start date and time end date and time 1 05/23/2014 10:00:00 AM 05/23/2014 11:00:00 AM 2 05/23/2014 11:00:00 AM 05/23/2014 01:00:00 PM 0.5 05/23/2014 02:00:00 PM 05/23/2014 02:30:00 PM Actually I want to enter time into 2nd and 3rd cell based on value on 1st column. The value is like : 1 = 1 hr, 2 = 2 hr and 0.5 = 30 mins. But in the first cell these values are entered as number, not in time format. Please suggest me anyone , any easier way to do this because manual entry is time consuming in excel. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Start/Repeat/Stop Macro at specific time/interval | Excel Programming | |||
| Code for auto filling in Excel based on number of months, & start date | Excel Programming | |||
| How do I get Exel to return # of hrs. worked, start time is enter | Excel Worksheet Functions | |||
| VBA that automatically generates a series of cash flows based on a start date, an end date and frequency | Excel Programming | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
Threaded Mode
