Time difference

[Guest]

Hi,
In Col. 'A' a time is enter through time(08,0,0) function and in Col. 'B'
the current time through Now() function. How I can calculate the difference
or the number of hours and minutes laps between two times.
please help me to get the answer.
thanks..

 

[Frank Kabel]

Hi
use
=B1-A1
and format as time

or if the time can span midnight try
=B1-A1+(B1<A1)

 

[Guillermo]

if you use time(8,0,0) then you don't care about the date.
If this is the case, you have to substract the date part from the now()
function
Therefore, column B should be:
=NOW()-FLOOR(NOW,1)
which gets rid of the integer part (date)
and then column C is just:
B - A
You're just going to get a decimal number; format it as hh:mm and you'll get
what you want


guillermo

 

[Guest]

thanks to both of you.
both formats are working...