| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating date/time with blank cells
A B C D
03/31/07 17 40 3/31/07 17:40 04/01/07 14 45 4/1/07 14:45 04/01/07 13 45 4/1/07 13:45 1/0/00 0:00 04/01/07 21 40 4/1/07 21:40 1/0/00 0:00 1/0/00 0:00 Can anyone tell me how I can just get a blank cell in column D when there is no data to calculate . I'm using this formula: =A2+B2/24+C2/(24*60) Thank you in advance for your time Deb |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Skipping blank cells when calculating time difference | Excel Discussion (Misc queries) | |||
| calculating average with blank cells | Excel Worksheet Functions | |||
| Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Calculating effective time from start/end date+time | Excel Worksheet Functions | |||
Threaded Mode
