Which formula is correct for calculating times?

Giganews Newsgroups
Subject: Which formula is correct for calculating times?
Posted by:  djm (djm.27gm1m_1147042502.264@excelforum-nospam.com)
Date: Sun, 7 May 2006

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 are:




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's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=4793
View this thread:http://www.excelforum.com/showthread.php?threadid=539705