+ Reply to Thread
Results 1 to 3 of 3

Excel 2007 : excel formula question

  1. #1
    Registered User
    Join Date
    04-24-2012
    Location
    usa
    MS-Off Ver
    2007
    Posts
    1

    excel formula question

    I have Vista. I'm not even sure where to look to see my excel / microsoft version so that may give you an idea of my working knowledge of my computer.

    I have a little bit of knowledge on using an excel sheet. Basic stuff. I use it to track time off available. The time on my worksheet is different than the time in the timekeeper. They do time coversion. For example, 19.63 hours on my timesheet would show up in timekeeper as 19.38 hours. I want my excel sheet to match the timekeeper. Is there a formula for this?

    Say 19.63 is in box E3. What formula (if there is one) would I type in box F3 to make 19.38 pop in there?

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2007, 2010
    Posts
    31,576

    Re: excel formula question

    =dollarfr(c23,60)
    Microsoft MVP - Excel
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2007, 2013
    Posts
    6,514

    Re: excel formula question

    Hi ALR, welcome to the forum.

    Please be sure to read the forum rules (link in my signature below) before posting again, specifically Rule #1 regarding thread titles.

    Thank you.

+ 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