Prev: Formula help please
Next: formula to return value from a matrix - I know hor and vert values
From: Bob Phillips on 6 May 2010 07:32
Use

=MOD(B1-A1,1)

--

HTH

Bob

"Ian R" <nospam(a)nopsam.com> wrote in message
news:MPG.264caaf851b12059989682(a)news.btinternet.com...
> Hi
>
> I'm using Excel 2003.
>
> I'm trying to calculate the total hours (C1) by subtracting end time
> (B1) from start time (A1)
>
> I have formatted the cells for time.
>
> I'm currently using B1-A1 which works OK until the end time goes past
> midnight.
>
> e.g start 19:50 end 00:20 should = 4:30 except i just get an endless
> series of #######
>
> Thanks for your time.
>
> Ian


From: Bob Phillips on 6 May 2010 08:08
Are you sure your clock is right, yours was the last to hit this thread, but
is timed the earliest!

--

HTH

Bob

"p45cal" <p45cal.4ajdtt(a)thecodecage.com> wrote in message
news:p45cal.4ajdtt(a)thecodecage.com...
>
> If the result is never over 24 hours try:
> =IF(B1>A1,B1-A1,B1+1-A1)
>
>
> Ian R;717898 Wrote:
>>
> Hi
>>
>> I'm using Excel 2003.
>>
>> I'm trying to calculate the total hours (C1) by subtracting end time
>> (B1) from start time (A1)
>>
>> I have formatted the cells for time.
>>
>> I'm currently using B1-A1 which works OK until the end time goes past
>> midnight.
>>
>> e.g start 19:50 end 00:20 should = 4:30 except i just get an endless
>> series of #######
>>
>> Thanks for your time.
>>
>> Ian
>
>
> --
> p45cal
>
> *p45cal*
> ------------------------------------------------------------------------
> p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
> View this thread:
> http://www.thecodecage.com/forumz/showthread.php?t=201009
>
> http://www.thecodecage.com/forumz
>


From: p45cal on 6 May 2010 09:43

Yeah. I'm posting at thecodecage.com. I know it's been having some
server problems lately.



B
o
b

P
h
i
l
l
i
p
s
;
7
1
7
9
6
6

W
r
o
t
e
:


>
Are you sure your clock is right, yours was the last to hit this thread,
but
> is timed the earliest!
>
> --
>
> HTH
>
> Bob
>
> "p45cal" <p45cal.4ajdtt(a)thecodecage.com> wrote in message
> news:p45cal.4ajdtt(a)thecodecage.com...[color=blue]
> >
> > If the result is never over 24 hours try:
> > =IF(B1>A1,B1-A1,B1+1-A1)
>


--
p45cal

*p45cal*
------------------------------------------------------------------------
p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=201009

http://www.thecodecage.com/forumz

From: Ian R on 8 May 2010 17:10
In article <MPG.264caaf851b12059989682(a)news.btinternet.com>,
nospam(a)nopsam.com says...
> Hi
>
> I'm using Excel 2003.
>
> I'm trying to calculate the total hours (C1) by subtracting end time
> (B1) from start time (A1)
>
> I have formatted the cells for time.
>
> I'm currently using B1-A1 which works OK until the end time goes past
> midnight.
>
> e.g start 19:50 end 00:20 should = 4:30 except i just get an endless
> series of #######
>
> Thanks for your time.
>
> Ian
>

Thanks to you all for taking the time to reply.

Its working perfectly now - just what I needed!

Much appreciated.

Ian I^)

First  |  Prev  | 
Pages: 1 2
Prev: Formula help please
Next: formula to return value from a matrix - I know hor and vert values