Hello everyone - hopefully you can help me!
I'm trying to create a timesheet that automatically calculates time worked.
I have a Data Validation for Time inserted into cells A13 & D13. In Cell C13, I put 30 (to indicate 30 minutes for lunch).
I can't get it to total the time worked minus the 30 minutes of lunch.
any help writing out this formula would be SO appreciated!
timeexcel.JPG
Last edited by TWP; 12-17-2018 at 03:50 PM. Reason: SOLVED
Lunch mentioned as 00:30
and simpleFormula:
Please Login or Register to view this content.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
If you wanted to keep the lunch formatted as it is, you can use something like this:
=D13-A13-C13/1440
Yes!! I want to keep it simple for my staff, to just put in 30 without the colon : separating the numbers to show the lunch.
Thank you! This worked well!!!
You're welcome. Happy to help.
FYI, there are 1440 minutes in a day. That's where the 1440 comes from.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks