I’m working on a very simple time sheet for my work in Excel 2007, but I have run into trouble about calculate the hours and minutes between two time periods.
I have a field:
timestart which could be for example: 08:30
Then I have a field
timestop which could be for example: 12:30
I can easy calculate the result myself which is 4 hours but how do I create a “total” table all the way down the cell that calculates the hours spend on each entry?
I’ve tried to play around with the time settings but it just give me wrong numbers each time.