Could anyone help me with this?
I’ve got a spreadsheet and I have three columns that are giving me a little trouble.
Column K is my start time. Column L is my end time. Column M is the number of hours that are created.
I created a formula that adds up the time, note that I’m only concerned about the number of hours up to 8, so even if there are more than 8 hours, the max number in this column would be 8 since this column is only used to document straight time:
=IF(M13>8,8,(8-M13)) this formula works
If someone doesn’t enter a start time, I want Column M to read “Enter Start Time” so I made this formula:
=IF(K18="",”Enter Start Time”,0) and this works fine.
But once a Start Time is entered, I want Column M to change to read “Enter End Time”
And once an End Time is entered I want the formula to work to add up the hours.
If someone doesn’t enter either a start time or an end time, I want Column M to read “Enter Time”
So I can do bits and pieces of what I want but not everything I want. Could someone please help? I've watched a few youtube videos but did not get very far.
Thanks in advance.
Bookmarks