Results 1 to 5 of 5

How do I calculate time in excel

Threaded View

  1. #1
    Registered User
    Join Date
    07-05-2015
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    5

    Angry How do I calculate time in excel

    I am doing a spreadsheet for my boss for hours worked. For example I would enter 1.4 for 1hr and 40 minutes and the 1.2 for 1hr 20 minutes. I know it is backwards but they bill out in 10 minute increments. How do I get excel to add 1.4 and 1.2 so it equals 3 hrs.

    Or for example 10 minute = 0.17 and 20 minutes = 0.33 but when excel adds 0.17+0.17 using the SUM formula it equals 0.34 instead of 0.33.
    I'm frustrated and at a loss. Any advice would be appreciated.
    Last edited by rmlane123ca; 07-05-2015 at 03:36 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 05-13-2015, 07:17 AM
  2. Excel Formula to Calculate Time Span Between Different Time Range.
    By omershafiq2012 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-06-2015, 08:28 AM
  3. How do i get time in excel to calculate time between 20:00-03:45
    By peter in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2006, 05:10 PM
  4. HOW DO I CALCULATE TIME IN A TIME SHEET FOR EXCEL
    By RAFAEL in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 06-26-2005, 07:05 PM
  5. [SOLVED] How do i calculate the time between 10:00 pm and 6:00 am in excel?
    By TMbender in forum Excel General
    Replies: 3
    Last Post: 05-15-2005, 11:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1