Time formulas
 

How do I make a formula for a time that starts at night, (23:30) and ends the
following day (09:00) and come out to be 12.5???? I can make it work for
times on the same day like (09:00 and ends at 23:00) and it shows up as 12.5.
I don't want to have to use a date along with the tme. I sure hope there is
a way to make it work.

Time formulas
 

It should be 9.5, *not* 12.5

Start time in A1,
End time in B1,

In C1:
=Mod(B1-A1,1)*24

With C1 formatted to General or Number.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tom S" <Tom wrote in message
...
How do I make a formula for a time that starts at night, (23:30) and ends
the
following day (09:00) and come out to be 12.5???? I can make it work for
times on the same day like (09:00 and ends at 23:00) and it shows up as
12.5.
I don't want to have to use a date along with the tme. I sure hope there
is
a way to make it work.

Time formulas
 

Thanks, looks like it is working for me

"Ragdyer" wrote:

It should be 9.5, *not* 12.5

Start time in A1,
End time in B1,

In C1:
=Mod(B1-A1,1)*24

With C1 formatted to General or Number.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tom S" <Tom wrote in message
...
How do I make a formula for a time that starts at night, (23:30) and ends
the
following day (09:00) and come out to be 12.5???? I can make it work for
times on the same day like (09:00 and ends at 23:00) and it shows up as
12.5.
I don't want to have to use a date along with the tme. I sure hope there
is
a way to make it work.

Time formulas
 

Appreciate the feed-back.
--

Regards,

RD
-----------------------------------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
-----------------------------------------------------------------------------------------------

"Tom S" wrote in message
...
Thanks, looks like it is working for me

"Ragdyer" wrote:

It should be 9.5, *not* 12.5

Start time in A1,
End time in B1,

In C1:
=Mod(B1-A1,1)*24

With C1 formatted to General or Number.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Tom S" <Tom wrote in message
...
How do I make a formula for a time that starts at night, (23:30) and
ends
the
following day (09:00) and come out to be 12.5???? I can make it work
for
times on the same day like (09:00 and ends at 23:00) and it shows up as
12.5.
I don't want to have to use a date along with the tme. I sure hope
there
is
a way to make it work.