View Poll Results: how to calculate elapse time in regular 2 decimal numeric value.

Voters
0. This poll is closed

  • .

    0 0%

  • .

    0 0%
Multiple Choice Poll.
+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : it admin

  1. 08-17-2009, 02:52 PM #1
    3jmj
    3jmj is offline
    Registered User
    Join Date
    08-17-2009
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    1

    Angry it admin



    I have this excel as my time sheet, it is using military time.

    How to calculate the elapsed hours in a regular 2 decimal number format.
    Example:
    Date In Out Total
    8/10/09 9:65 14:08 4.43 (this is the format I want on this column.)

    Please help
    Reply With QuoteRegister To Reply
  2. 08-17-2009, 06:14 PM #2
    Paul
    Paul is offline
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885

    Re: it admin

    Hello 3jmj, and welcome to the forum.

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem (per rule #1). Thank you.
    - Paul

    Click here to read the Forum Rules

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1