G
Guest
I´m trying to make a timesheet, so far I have total hours but the daytime
hours are from 7:30am to 16:30pm. Is there a formula that counts the hours
worked within this time and put´s that number in one cell and puts extra
hours in another cell.
I know that this might be hard to find out, couse I want to have it easy for
me to use, it would be best if I could enter the starttime and endtime for
each day and excel would calculate the rest.
hours are from 7:30am to 16:30pm. Is there a formula that counts the hours
worked within this time and put´s that number in one cell and puts extra
hours in another cell.
I know that this might be hard to find out, couse I want to have it easy for
me to use, it would be best if I could enter the starttime and endtime for
each day and excel would calculate the rest.