Calculating daily time absence of multiple users, based on 8 hour schedule.

**janeu** · 10-05-2012, 07:32 AM

Hello everybody,

I have the following table, always sorted by user name.
I want to calculate the absense of each user daily.
Counting starts from the first check in (last check out not required).
There is no need to record time presence above 8 hours.
Any way of making cells>8 hours vanish-invisible-blank-white

?
Any recommandations-different approach?

Thank you in advance for your time and effort.

**dilipandey** · 10-05-2012, 07:49 AM

Hi Janeu,

Welcome to the forum.

See the attached file .. column L,M,N,O and let me know if this helps.. thanks.

123.xls

Regards,
DILIPandey

<click on below 'star' if this helps>

**janeu** · 10-05-2012, 07:57 AM

Nicely done, but you placed check-in, check-out times horizontally while my file have them vertically.
I don't know how to make it work/make the switch.
Thanks again!

edit:I know it is copy-paste,but maybe you know how i can avoid it

**dilipandey** · 10-05-2012, 08:07 AM

We can place them vertically as well.. but that will not good.. why don't you use pivot table.. see attached. thanks.
123.xls

Regards,
DILIPandey

<click on below 'star' if this helps>

**janeu** · 10-05-2012, 08:15 AM

I think i 'll stay with your first example,which already solves my problem.
I am going to read about pivot tables now...

Thank you again!

**dilipandey** · 10-05-2012, 08:28 AM

you are welcome..!!

suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

Calculating daily time absence of multiple users, based on 8 hour schedule.

LinkBack

Thread Tools

Rate This Thread

Display

Calculating daily time absence of multiple users, based on 8 hour schedule.

Re: Calculating daily time absence of multiple users, based on 8 hour schedule.

Re: Calculating daily time absence of multiple users, based on 8 hour schedule.

Re: Calculating daily time absence of multiple users, based on 8 hour schedule.

Re: Calculating daily time absence of multiple users, based on 8 hour schedule.

Re: Calculating daily time absence of multiple users, based on 8 hour schedule.

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions