ExcelBanter - Convert time unit

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Convert time unit (https://www.excelbanter.com/excel-worksheet-functions/180784-convert-time-unit.html)

BPIPRES

Convert time unit

How do I convert time units from ET to PT (subtract 3 hours)?

Mike H

Convert time unit

=A1 - TIME(3,0,0)

Mike

"BPIPRES" wrote:

How do I convert time units from ET to PT (subtract 3 hours)?

All times are GMT +1. The time now is 07:16 AM.