+ Reply to Thread
Results 1 to 2 of 2

Looking for formula help finding total hours worked in military time

  1. #1
    Registered User
    Join Date
    04-08-2015
    Location
    USA
    MS-Off Ver
    2013
    Posts
    1

    Angry Looking for formula help finding total hours worked in military time

    A1-Time IN and B1-Time Out, Using military time ex. 23:00hrs or 03:00hrs. Any help would be appreciated!!!

  2. #2
    Valued Forum Contributor
    Join Date
    04-12-2012
    Location
    India
    MS-Off Ver
    Excel 2007, 2010, 2013, 2016, 2019, Office 365, Google Spreadhsheet
    Posts
    640

    Re: Looking for formula help finding total hours worked in military time

    Hi Mic,

    Welcome to the forum.

    Select A1 & B1 and then do the right click and go to "Format Cells" and Select "Time" from category and there you have option to choose your own time format.
    Thanks,
    Anil Dhawan


    Click *Add Reputation to say "Thanks" and don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved) if you are satisfied.

    Don't stop when you are tired. STOP when you are done!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula tp ca;culate hours worked using military hours and standard minutes
    By Vicki Steffen in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-24-2014, 03:03 PM
  2. Figuring military time for total hours
    By David Nelms in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  3. [SOLVED] Figuring military time for total hours
    By David Nelms in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  4. [SOLVED] Figuring military time for total hours
    By David Nelms in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  5. [SOLVED] Figuring military time for total hours
    By David Nelms in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-05-2005, 12:05 PM

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