Question about Excel

Discussion in 'Microsoft Office' started by dabits, Jan 1, 2012.

  1. dabits

    dabits Guest

    I want to use Excel to check something, I know a little bit about Excel and formulas but I'm no expert.
    It's about (end time) - (start time) - (extra time) = (total time), per day + week + 4 weeks.
    To keep things simple I tried using minutes, so I ended up with 480/day and 2400/week.

    Using (example) 2067/60 got me 34.45, so I needed a formula to calculate the result in hh:mm (example) 2067 = 34:27 or 34.27

    So I tried (Format Cells > Time > hh:mm) and I got the result per day in hh:mm.
    But if I calculated the total of 5 days, this didn't work as I hoped.
    I got the result as a time (example) 10:27 (= 34:27)
    What do I need to do to get 34:27 or 34.27 as the result?

    3:5513:220:328:55
    3:5512:500:338:22
    3:5513:050:508:20
    0:00
    2:5712:471:008:5010:27

    Or what formula do I need for the first idea (example) 2067 = 34:27 or 34.27
     
  2. spiralien

    spiralien MDL Senior Member

    Aug 25, 2009
    275
    514
    10
    =int(2067/60)+(mod(2067;60)/100) ---> 34.27
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...