cansevin

<div>
<div class="content wysiwyg-content fr-view">
I have a row of dates with times in row K. I need to subtract 1 hour and 20 minutes in the row next to it. Format is below:<br><br>&nbsp;<table><tbody><tr><td class="xl63">3/9/2020 7:56</td></tr><tr><td class="xl63">3/11/2020 13:04</td></tr><tr><td class="xl63">3/11/2020 14:41</td></tr><tr><td class="xl63">3/12/2020 8:57</td></tr><tr><td class="xl63">3/16/2020 13:13</td></tr><tr><td class="xl63">3/17/2020 11:48</td></tr><tr><td class="xl63">3/18/2020 12:03</td></tr><tr><td class="xl63">3/19/2020 11:22</td></tr><tr><td class="xl63">3/20/2020 13:05</td></tr></tbody></table><br>
</div>
</div>



I have a row of dates with times in row K. I need to subtract 1 hour and 20 minutes in the row next to it. Format is below:
 
3/9/2020 7:56
3/11/2020 13:04
3/11/2020 14:41
3/12/2020 8:57
3/16/2020 13:13
3/17/2020 11:48
3/18/2020 12:03
3/19/2020 11:22
3/20/2020 13:05

Subtract 1 Hour and 20 Min

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.