ExcelBanter - how to subtract time cards in minutes in excel

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

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

- - how to subtract time cards in minutes in excel (https://www.excelbanter.com/excel-worksheet-functions/29343-how-subtract-time-cards-minutes-excel.html)

excelsior

how to subtract time cards in minutes in excel

can excel be set up to allow the subtracting of time cards that are in hours
and minutes and give the answer in the same format?

Biff

Hi!

A1 = 3:00 PM
B1 = 11:00 PM

=B1-A1+(A1B1)

Format the cell as [h]:mm

Biff

"excelsior" wrote in message
...
can excel be set up to allow the subtracting of time cards that are in
hours
and minutes and give the answer in the same format?

All times are GMT +1. The time now is 04:22 PM.