ExcelBanter - subtraction off time after midnight

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

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

- - subtraction off time after midnight (https://www.excelbanter.com/excel-worksheet-functions/90209-subtraction-off-time-after-midnight.html)

Steved

subtraction off time after midnight

Hello from Steved

I have 7:10 p.m. to 12:15 a.m.

What formula do I use to subtract 12:15 a.m. from 7:10 p.m. please.

I would like it to show 05:05

Thankyou.

Roger Govier

subtraction off time after midnight

Hi Steve
With 12:15 AM in A1 and 7:10 PM in A2
=MOD(A1-A2,1)

--
Regards

Roger Govier

"Steved" wrote in message
...
Hello from Steved

I have 7:10 p.m. to 12:15 a.m.

What formula do I use to subtract 12:15 a.m. from 7:10 p.m. please.

I would like it to show 05:05

Thankyou.

Steved

subtraction off time after midnight

Hello Roger

Excellent and Thankyou.

"Roger Govier" wrote:

Hi Steve
With 12:15 AM in A1 and 7:10 PM in A2
=MOD(A1-A2,1)

--
Regards

Roger Govier

"Steved" wrote in message
...
Hello from Steved

I have 7:10 p.m. to 12:15 a.m.

What formula do I use to subtract 12:15 a.m. from 7:10 p.m. please.

I would like it to show 05:05

Thankyou.

All times are GMT +1. The time now is 05:03 AM.