Excel Function to Calculate Time Differences (Like a worker time card)

I need an Excel function that can calculate a worker's total hours for a day.

For each day, there are a series of two or four times.

If there are two times, it is a "shift start" and "shift end" for a shift.

If there are four times, there is a "shift start", "lunch start", "lunch end", "shift end".

I need a column to show the "lunch time" (if the employee clocked out for lunch), and then the total shift time (the difference between the "shift start" and "shift end", minus the "lunch time"). The result should be in decimal format ("7.5" hours instead of "7:30" hours)

Some of the shifts extend past midnight, so it will also need to account for overnight calculations.

The columns are set up this way:

| A | B | C | D | E | F |

| Date | Name | Shift Start (IN) | Lunch Start(Out) | Lunch End (IN) | Shift End (OUT) |

I've put a screen grab of the spreadsheet here:

[url removed, login to view]

Habilidades: Instalação de Script, Shell Script

Veja mais: excel 16, need a employee, i need a employee, a b, time series, jpg to excel, i need a worker, excel function, differences, time card, time time employee, excel name card, function time, card excel spreadsheet, time card employee, series script, shell column, spreadsheet lunch, time card excel, end time, excel spreadsheet set, time series script, name card excel, shifts excel, time difference

Acerca do Empregador:
( 14 comentários ) United States

ID do Projeto: #2732418

Concedido a:


See private message.

$39 USD em 1 dia
(12 Comentários)

3 freelancers estão ofertando em média $37 para esse trabalho


See private message.

$40 USD em 1 dia
(0 Comentários)

See private message.

$30.6 USD em 1 dia
(0 Comentários)