Time sheet total hours worked

Question

Help!

i am trying to add up the total hours/minutes worked on a time sheet.

this is a piece of the data i have:

the Hours** field has the equation "=HOUR(F45-C45-(E45-D45))&": "& MINUTE(F45-C45-(E45-D45))" all "IN" and "OUT" fields are formatted as h:mm

the "copy of hours filed number only" field is where i have literally put "=(G45) to copy the number thinking i could add att the values in a hidden field.

the "Total Time" is not adding up to the sum of the hours or the copy field. it is coming up with 16.0 instead of total hours 112.

i have tried "total time" in both number and h:mm formatting.

Thur		IN	OUT	IN	OUT	Hours**	copy of hours field number only
5	2	7:30	12:00	12:30	18:00	10: 0	10: 0
Fri
6	2	7:30	12:00	12:30	16:00	8: 0	8: 0
Sat
7	2	6:00	10:30	11:00	14:30	8: 0	8: 0
Timesheet - Fortnightly  Collective	Total Time:	?????

Answer 1

Hi Jenny

Please refer to any of this videos that will help you to build your worked timesheet

https://youtu.be/Q5VMFZx9bdY

https://youtu.be/o\_3m90XPDJI

https://youtu.be/fl\_TCz6ZyC8

Do let me know if you require any further help on this. Will be glad to help you.

If this answer would be the solution to your question, I'll appreciate you mark it as answered

Please Note:

By marking a Reply as a "Accept as Solution", if it solves your problem. Will give positive reinforcement, not only to the person who responded, but also will help other users with the same or a similar question by directing them to the response.Thanks for your co-operation.

Answer 2

OMG! so easy now.

thanks so much.

first link solved the issue - i was over complicating things again :)