+ Reply to Thread
Results 1 to 7 of 7

Annal leave timesheet - hours to work days 7.5hr

  1. 07-13-2020, 06:17 AM #1
    pooley
    pooley is offline
    Registered User
    Join Date
    06-25-2012
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    8

    Annal leave timesheet - hours to work days 7.5hr

    I've moved my wifes annual leave from from word to excel.

    I would like it to show AL entitlement in days as well as hours, her working day is 7.5hrs.

    I've looked at 8hr working day examples but cannot alter them succefully to show a 7.5 hr working day.

    Any help appreciated.

    Simon
    Attached Files Attached Files
    Last edited by pooley; 07-13-2020 at 07:17 AM.
    Reply With QuoteRegister To Reply
  2. 07-13-2020, 06:45 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,351

    Re: Annal leave timesheet - hours to work days 7.5hr

    Erm ...

    Sorry - what and where are 'hads'?
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-13-2020, 07:18 AM #3
    pooley
    pooley is offline
    Registered User
    Join Date
    06-25-2012
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Annal leave timesheet - hours to work days 7.5hr

    Sorry fat fingers, "Days" . Edited post now
    Last edited by AliGW; 07-13-2020 at 09:10 AM. Reason: Please don't quote unnecessarily!
    Reply With QuoteRegister To Reply
  4. 07-13-2020, 09:12 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,351

    Re: Annal leave timesheet - hours to work days 7.5hr

    Thanks, but I'm still unclear about this. Where are the results you want to see? These should be mocked up manually for 10-15 rows of data and added to your sample WB.
    Reply With QuoteRegister To Reply
  5. 07-13-2020, 11:11 AM #5
    pooley
    pooley is offline
    Registered User
    Join Date
    06-25-2012
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    8

    Re: Annal leave timesheet - hours to work days 7.5hr

    Apologies I forgot to label the column.

    New one attached.

    Simon
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 07-13-2020, 11:14 AM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,351

    Re: Annal leave timesheet - hours to work days 7.5hr

    Please reread what I asked:

    Where are the results you want to see? These should be mocked up manually for 10-15 rows of data and added to your sample WB.
    Reply With QuoteRegister To Reply
  7. 07-13-2020, 05:13 PM #7
    forestview
    forestview is offline
    Forum Contributor
    Join Date
    07-16-2015
    Location
    Aberdeen, Scotland
    MS-Off Ver
    Excel 2010
    Posts
    121

    Re: Annal leave timesheet - hours to work days 7.5hr

    Hi Simon

    I agree with AliGW #6 also your sheet is bloated with merged cells which are best removed as very rarely required.

    Forestview
    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)

Similar Threads

  1. Timesheet with Highlight Annual Leave and auto populate hours in cells
    By ismailshajji in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-04-2019, 07:25 PM
  2. [SOLVED] Calculating Years, Months, Week, Days, Hours, Minutes for Work Days between two dates
    By hecgroups in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-23-2019, 12:09 AM
  3. Creating an automated timesheet to keep track of work hours
    By EdwardSnowden in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-09-2017, 12:22 AM
  4. Formula to work out Leave days due
    By RobynIPGroup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-04-2015, 03:49 AM
  5. Work Schedule that calculates hours, lunches, days off and vacation days
    By tameronstarr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-12-2014, 12:06 PM
  6. [SOLVED] Timesheet with overtime calculation between certain hours, days only
    By ExcelNoviceHexham in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-02-2013, 12:21 PM
  7. How to subtract two dates (with hours) considering the work hours and work days
    By ella2 in forum Excel General
    Replies: 15
    Last Post: 06-17-2011, 03:37 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1