View original (French)

Calculate a time range with Excel

Solved
freretoc61 Posted messages 7 Status Member -  
freretoc61 Posted messages 7 Status Member -
Hello,
I would like to calculate a time range; the format of the cells is hours, e.g., 13:45
To keep it simple, I start my day at 6:00 and finish at 16:00, the duration of this day is
10:00.
Thank you for explaining or giving me a function for this calculation.

I hope I have explained clearly and I thank you in advance for your answers.

P.S.: Configuration Windows and Excel 2003 
Configuration: Windows XP Internet Explorer 7.0

2 answers

  1.
    eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello,

    you just do the subtraction.
    A1: 6:00
    A2: 16:00
    A3: =A2-A1 => 10:00
    If you have overlapping times over 2 days (start at 20:00, end at 03:00) use the following formula:
    =mod(A2-A1;1)

    eric
    3