Results 1 to 5 of 5

input and display data in cell in h:mm format without changing to time

Threaded View

  1. #1
    Registered User
    Join Date
    02-25-2010
    Location
    Virginia
    MS-Off Ver
    Excel 2007
    Posts
    25

    input and display data in cell in h:mm format without changing to time

    I am wondering if someone could help me with a formula that I can put into the cells B38-AF38, that would display the sum of B20:AF20 + B24:AF24 + B28:AF28 + B32:AF32
    +B36:AF36 in a h:mm format.

    When imputing the data into a cell in a h:mm format, I need it to display in that cell and formula bar the h:mm format without having to put an apostrophe in front of "h" or ":mm" value. Once complete, this form is going to go to other trainers to use on their computers and I dont think they would remember to keep putting an apostrophe before the data.

    Example:

    B20= 1:15 (1h15m) NOT 1:15:00 AM

    B24= :30 (30min)

    B28= :45 (45min)

    B32= 1:45 (1h45m) NOT 1:45:00 AM

    B38= 4:15 (4h15min)

    I have attached a copy of the form for better clarification.

    It doesnt seem to be complicated, but it's certainly a lot more than I thought.

    Thanks in advance.
    Attached Files Attached Files
    Last edited by k9mikep; 02-25-2010 at 04:42 PM.

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