+ Reply to Thread
Results 1 to 6 of 6

Sick leave annual leave minutes spreadsheet

  1. #1
    Registered User
    Join Date
    06-13-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Cool Sick leave annual leave minutes spreadsheet

    My computer has Excel 2003... When employees turn in their time for sick or annual leave, they will put down a number such as:
    7:45 (7hrs 45min)
    Or
    7.45
    ...I need a way to enter that on my spread sheet as time, but not am or pm time. And not a 24 hour time. I have to subtract it from their balance of hours and add in any new time accrued. Numbers sometime look like: 156.79 which should be 157 hrs 19 mins.

    I will appreciate any help that I can get!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sick leave annual leave minutes spreadsheet

    Hi news12kim,

    welcome to the forum.

    What data layout you have in your worksheet?
    Would it be fine if I give you a formula which will convert 156.79 to 157 hrs 19 mins but then how you would use this for subtraction purpose and hence a sample workbook required. Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Registered User
    Join Date
    06-13-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Sick leave annual leave minutes spreadsheet

    The top of my spreadsheet has these headings:

    Earned, Sick Leave Taken, Balance

    It is Excel 2003/// I am a newbie...

  4. #4
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sick leave annual leave minutes spreadsheet

    I guess a sample workbook is required with dummy data



    Regards,
    DILIPandey
    <click on below * if this helps>

  5. #5
    Registered User
    Join Date
    06-13-2013
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Sick leave annual leave minutes spreadsheet

    Carryover From Previous Year 102.20 Carryover from Previous Year: 25.45
    ANNUAL LEAVE SICK LEAVE
    Month Earned Taken Balance Earned Taken Balance
    July 12.10 40.00 74.30 10.00 2.00 318.45
    August 12.10 86.40 10.00 10.00 318.45
    Sept 12.10 98.20 10.00 22.00 306.45
    October 12.10 8.00 102.30 10.00 5.00 311.45
    Nov 12.10 16.00 98.40 10.00 8.00 313.45
    Dec 12.10 32.00 78.50 10.00 5.30 318.15
    January 12.10 91.30 10.00 17.00 311.15
    February 12.10 103.40 10.00 29.30 291.45
    March 12.10 16.00 99.50 10.00 5.00 296.45
    April 12.10 16.00 96.00 10.00 8.00 298.45
    May 12.10 8.00 100.10 10.00 16.00 292.45
    June

  6. #6
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Sick leave annual leave minutes spreadsheet

    Hi News12Kim,

    Click on "Go Advanced" while replying and then look for a paper clip icon to attach a file.
    I need to see a workbook having results - what you have & what you wish to achieve. Thanks.


    Regards,
    DILIPandey
    <click on below * if this helps>

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1