One way:

A1: 9:00 AM
A2: 5:00 PM

A3: =A2-A1 === 8:00

when A3 is formatted as h:mm

If you have shifts that span midnight:

A3: =MOD(A2-A1,1)

Since XL stores times as fractional days.

In article ,
jgullett wrote:

I am needing to calculate time in Excel 2003. Say someone comes in to work
at 9 AM and works until 5PM, how can I create a formula to automatically
count the total time worked?