Formula
the time will be entered at:
10 in cell A1
7 in cell B1
"Teethless mama" wrote:
Assuming
A1 = 10:00 AM
B1 = 7:00 PM
In C1: =(B1-A1)*24-1
Format cells as General
"Phxlatinoboi®" wrote:
i created a spreadsheet where i will be tracking hours for our sales people.
i want to automatically track what hours they work. they usually send me the
time as (ex. 10 - 7,). I would like to get a formula that would automatically
add the time up as hours worked and automatically deduct an hour off for
lunch. can someone help me with this?
|