From: Bob Phillips on 6 May 2010 07:32 Use =MOD(B1A1,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 B1A1 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,B1A1,B1+1A1) > > > 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 B1A1 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,B1A1,B1+1A1) >  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 B1A1 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 