View original (French)

Calculate a time range with Excel

Solved
freretoc61 Posted messages 7 Status Membre -  
freretoc61 Posted messages 7 Status Membre -
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 réponses

Réponse 1 / 2
eriiic Posted messages 24581 Registration date   Status Contributeur 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