![]() If no lunch was taken, then the formula breaks because it's trying to convert the blank lunch cells. This is how the table works with the data given and the formula above in col F. Table is: Date Time In Lunch Start Lunch End Time Out Total Hours I have to convert these to hours for payment purposes so first I have to convert them to time values. All values in the sheet are written as integers like 9. I have a sheet in numbers dealing with time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |