Time difference

I

ismail

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..
 
F

Frank Kabel

Hi
use
=B1-A1
and format as time

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

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
 
Top