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.
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.
Hi Steve
With 12:15 AM in A1 and 7:10 PM in A2
=MOD(A1-A2,1)
--
Regards
Roger Govier
"Steved" <[email protected]> wrote in message
news:[email protected]...
> 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.
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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks