+ Reply to Thread
Results 1 to 2 of 2

problem multiplying minutes and seconds

  1. #1
    Registered User
    Join Date
    07-15-2013
    Location
    USA
    MS-Off Ver
    2007
    Posts
    1

    problem multiplying minutes and seconds

    I need to calculate accrued vacation. For each hour worked an employee accrues 1 minute and 13 seconds of vacation. If an employee has worked 921 hours, how do I multiply 921 times 1:13 with the result in hours and minutes?
    Last edited by bnhinton; 12-27-2013 at 12:48 PM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,444

    Re: problem multiplying minutes and seconds

    Perhaps =A1*"00:01:13" and format as [h]:mm ? where A1 contains the hours worked?

+ 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. convert days hours minutes seconds to just minutes
    By hollylynn in forum Excel General
    Replies: 4
    Last Post: 08-28-2015, 08:53 AM
  2. Convert Days:Hours:Minutes:seconds to minutes.
    By Kevingardner1 in forum Excel General
    Replies: 4
    Last Post: 06-03-2014, 06:44 PM
  3. [SOLVED] Seconds to hours:minutes:seconds format
    By dalipsinghbisht in forum Excel General
    Replies: 1
    Last Post: 05-12-2013, 12:10 AM
  4. convert from seconds to form hours: minutes: seconds?
    By nguyen_han in forum Excel General
    Replies: 2
    Last Post: 10-13-2011, 06:56 AM
  5. Replies: 4
    Last Post: 01-18-2010, 04:29 AM

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