ExcelBanter - formula to subtract time, 12:10 am (00:10)

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

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - formula to subtract time, 12:10 am (00:10) - 11:50 pm (23:10) ? (https://www.excelbanter.com/new-users-excel/63871-formula-subtract-time-12-10-am-00-10-11-50-pm-23-10-a.html)

teezee

formula to subtract time, 12:10 am (00:10) - 11:50 pm (23:10) ?

Roger Govier

formula to subtract time, 12:10 am (00:10) - 11:50 pm (23:10) ?

Hi

One way
With 00:10 in A1 and 23:50 in B1
=MOD(A1-B1,1)

--
Regards

Roger Govier

"teezee" wrote in message
...

All times are GMT +1. The time now is 03:24 PM.