+ Reply to Thread
Results 1 to 5 of 5

Having problems with formatting time in a time sheet

  1. #1
    Registered User
    Join Date
    01-07-2014
    Location
    Decatur, Ga
    MS-Off Ver
    Excel 2007
    Posts
    3

    Having problems with formatting time in a time sheet

    I am constructing a time sheet. I need to be able to do the following, but cannot seem to figure out just how to do it.

    January
    Date: Sign In Sign out Total Time
    7-Jan-14

    I would like to be able to format the time and have it displayed in the 24 hour format so that the cell displays time like 08:00 for 8:00 AM or 23:45 for 11:45PM.
    Column A would have the date, Column B would display the 24 hour time format and Column C would calculate the difference between the times for pay purposes.
    I sure could use your help in figuring out how to format the times to display 24 hour format so that if I enter 800, it will display 08:00 or if I enter 2345 it will display 23:45.
    I also could use some help in coming up with the formula that will calculate the total time worked 24 hour day.
    Last edited by cptrosakelly; 01-07-2014 at 06:14 PM. Reason: Requestd by Forum Moderator

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: 2019 but still use also older versions
    Posts
    6,993

    Re: Time Sheet

    have you checked this thread? http://www.excelforum.com/excel-gene...onversion.html

  3. #3
    Registered User
    Join Date
    01-07-2014
    Location
    Decatur, Ga
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Time Sheet

    No this doesn't cover it.

    I am trying to format the cells so that I can get a time in the following format using the 24 hour clock instead of the standard. hh:mm
    When it go into format cells and choose the hh:mm, it connects it to a time and puts whatever is entered to all zeros: 00:00
    When you look at the format, it gives a date and then the time, but I don't want to connect this to a date. I just want to format the cells to show the entry in hh:mm format.
    Trying to create a time sheet

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    48,859

    Re: Time Sheet

    Hi 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. Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the adress bar)

    To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    01-07-2014
    Location
    Decatur, Ga
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Time Sheet

    To: Forum Moderator

    I am very new to this and have no clue what you are talking about. I will edit the title appropriately, but all that other stuff, I have no clue what you are talking about and I have no clue how to PM you.

    I have read the rules, but I don't understand the code portion that it is referring too.

    Maybe this forum is not for newbies like me. I was just trying to find someone who was more versed on this then me.
    Last edited by cptrosakelly; 01-07-2014 at 06:17 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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