On excel how can I get totals when denoting D (day) when creating.

[Guest]

When creating a schedule for a number of employees on a daily 4-week
spreadsheet, How can I total Shifts when they are designated "D" for day
shift instead of a numerical value as 12 hours?

 

[Guest]

=IF(A1="D",12,IF(A1="N","whatever nightshift hours
are",""))

and you can nest additional IF statements for other shifts
you might have.

 

[JE McGimpsey]

One way:

=COUNTIF(rng, "D")

or, for 12 hours per shift as integer hours:

=COUNTIF(rng,"D")*12

or, for 12 hours per shift as a time:

=COUNTIF(rng,"D")/2

(format the cell as Time).

 

[Alan]

If in colmn C, range C1:C25 there were four 'D's
=COUNTIF(C1:C25,"D") will count the 'D's and return four,
Regards,