Excel formula – hours as a fractional result between two time?

Posted on July 15th, 2010 by admin in minutes template | 1 Comment »

I’m looking for an Excel formula that will calculate hours as a FRACTIONAL result, rather than whole hours or as hours and minutes. For example, I need the result between 12:00 PM and 2:15 PM to be expressed as 2.25 hours rather than 2:15 (two hours and 15 minutes). This is for a timesheet template for work.

Say you have 2:15 in cell A1 and 12:00 in cell A2. Then your formula should be:
(A1-A2)*24

One Response

  1. James Says:
    July 15th, 2010 at 3:51 pm

    Say you have 2:15 in cell A1 and 12:00 in cell A2. Then your formula should be:
    (A1-A2)*24
    References :

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.

|