how do i get the hours between these times??

H

hendersson

hi!

i have the following scenario:

if a person works between i.e. 08:00 and 21:00 i need to have a column
that says how many hours and minutes it is between

08:00 and 18:00
18:15 and 20:00
20:00 and infinit

i also have to have in mind that a person very well can work between
i.e. 08:00 and 19:00.

someone have a good solution for me =) ?

thanks!
 
W

widemonk

If your times are dead text, you could use
=TIMEVALUE("12:00")-TIMEVALUE("08:00") and format the cell as 'time',
though this method isnt really what excel is used for.

A better way would be simply to have a cell with the start time,
another cell with the finish time and a third cell as the usual =A2-A1.
 
H

hendersson

hmmm,,,,i don´t think you understand me, i have problems with th
subtraction that is what i need help with, this is my exampel sheet:

A1 A2 A3 A4 A5
09:00 21:00 9,15 h 1,75 h 1 h
09:00 19:00 9,15 h 0,75 h

A1 = beginning work
A2 = ending work
A3 = hours between A1 and and 18:15
A4 = hours between 18:15 and 20:00
A5 = hours after 20:00

how do i get values under A4 and A5
 
Top