Paging Excel gurus days, hours, minutes...

Discussion in 'UK Motorcycles' started by Hog, Jan 28, 2011.

  1. Hog

    Hog Guest

    I'm having a minor brain storm, struggling with an (apparently) simple
    issue.

    Cell 1 format: dd/mm/yyyy hh:mm
    Cell 2 format: dd/mm/yyyy hh:mm

    Cell 3: I want to display Cell2 minus Cell1 expressed as a total of hours
    and minutes hhh.xx

    Then I'll apply to a range
     
    Hog, Jan 28, 2011
    #1

    1. Advertisements

  2. Hog

    Scraggy Guest


    "If cell2<cell1; then+ pi to aga" sort of thing?
     
    Scraggy, Jan 28, 2011
    #2

    1. Advertisements

  3. Hog

    Catman Guest

    [h]:mm

    Should to it

    HTH

    --
    Catman MIB#14 SKoGA#6 TEAR#4 BOTAFOF#38 Apostle#21 COSOC#3
    Tyger, Tyger Burning Bright (Remove rust to reply)
    116 Giulietta 3.0l Sprint 1.7 GTV TS GT 3.2 V6
    Triumph Sprint ST 1050: It's blue, see.
    #www.cuore-sportivo.co.uk
     
    Catman, Jan 28, 2011
    #3
  4. Hog

    Hog Guest

    <sigh>
    Thanks

    Fucked Memory Syndrome
     
    Hog, Jan 28, 2011
    #4
  5. Hog

    Catman Guest

    De nada. I only know cos I had exactly the same issue recently. I had to
    ask someone else.

    --
    Catman MIB#14 SKoGA#6 TEAR#4 BOTAFOF#38 Apostle#21 COSOC#3
    Tyger, Tyger Burning Bright (Remove rust to reply)
    116 Giulietta 3.0l Sprint 1.7 GTV TS GT 3.2 V6
    Triumph Sprint ST 1050: It's blue, see.
    #www.cuore-sportivo.co.uk
     
    Catman, Jan 28, 2011
    #5

    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads

  1. Paging All Suspension Setup Gurus...

  2. Paging : MIDI gurus

  3. Fist ride in 16 weeks 6 days and 17 hours

  4. 3 days, 3 whole kin days

  5. (paging Champ) A Brit ducatista in the Barcelona 24 hours 50th anniversary

  6. Paging Excel geeks

  7. Ping the Excel gurus.

  8. Four hours. Four bloody hours!

Loading...