Thread
:
time problems
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Sandy Mann
external usenet poster
Posts: 2,345
time problems
Try:
=MOD(A2-A1,1)
--
HTH
Sandy
In Perth, the ancient capital of Scotland
with @tiscali.co.uk
"Stan Halls" wrote in message
...
I have a spread sheet and in this sheet i have a set time that it takes to
do
a run ie 01:30 1 hour 30 mins (A1)
then i have another cell that i input a time (A2) and a 3rd cell that has
an if function that says =if( a20, a2-a1,"") this works fine untill the
time
difference goes back past midnight, if A2 = 01:00 and A1= 01:30 then i get
###### instead of 23:30, in lotus 123 it worked fine but excel seems to
have
a problem with this, any ideas what i am doing wrong ?
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann