View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Which formula is correct for calculating times?

Hi!

They both seem to work (not exhaustively tested) but give this a try:

=MIN((O31-N31+(O31<N31))*24,7.25)

Biff

"djm" wrote in message
...

I built a spreadsheet to calculate hours worked; I did it over a couple
of weeks, reading and learning as I went. During the time I was doing
this, somehow I ended up with 2 different formula for calculating hours
worked...these a

=IF(N31O31,MIN(("24:00"-N31+O31)*24,7.25),MIN((O31-N31)*24,7.25))

and

=IF(N32O32,CEILING(("24:00"-N32+O32),7.25),MIN((O32-N32)*24,7.25))

where N and O are the start & finsh times respectively.

Both seem to calculate properly, but does anyone know which is the
better formula to use...of does it matter ? Thanks.


--
djm
------------------------------------------------------------------------
djm's Profile:
http://www.excelforum.com/member.php...fo&userid=4793
View this thread: http://www.excelforum.com/showthread...hreadid=539705