- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2006 May
- Which formula is correct for calculating times?

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:

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

and

=IF(N32>O32,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?action=getinfo&userid=4793

View this thread:http://www.excelforum.com/showthread.php?threadid=539705

- Re: Which formula is correct for calculating times? posted by daddylonglegs on Sun, 7 May 2006
- Re: Which formula is correct for calculating times? posted by Biff on Sun, 7 May 2006