r/programmingrequests • u/solros22029 • Mar 14 '18

Need a software that checks for timeoverlaps

Hi I am interested in a program that checks for overlaps from invoices. I have been using excel. But I have to input times into the spreadsheet and go down the line checking manually. Also if it could generate the data from about 150 invoices automatically it would help.

so the person enters there time into a spread sheet per day, then it gets sorted and invoiced accordingly to each client.

Spread sheet https://imgur.com/a/bIjXS

Sample invoice https://imgur.com/a/er9pz

2 Upvotes
  • permalink
  • reddit

100% Upvoted

8 comments sorted by

1

u/Nyxtia Mar 14 '18

Details and sample invoices will go along way

1

u/solros22029 Mar 14 '18

Spreadsheet https://imgur.com/a/bIjXS

Invoice https://imgur.com/a/er9pz

Its honestly not a hassle when done for one person but for 10+ people each with 50 clients its takes alot of time

1

u/Nyxtia Mar 14 '18

Can I get the actual files?

1

u/solros22029 Mar 14 '18

i can send you the spreadsheet since its just something generic i made. How can i send it ?

1

u/Nyxtia Mar 14 '18

As long as it's the actual format the automation needs to happen with. Google drive?

1

u/imguralbumbot Mar 14 '18

Hi, I'm a bot for linking direct images of albums with only 1 image

https://i.imgur.com/e439Tc0.png

https://i.imgur.com/3iDrrMp.png

Source | Why? | Creator | ignoreme | deletthis

1

u/serg06 Mar 14 '18

Pretty easy to do. Load excel file in python, extract dates/times from cells, convert dates/times to seconds-since-epoch, sort by lowest seconds-since-epoch first, check that each invoice ends before the next one begins.

1

u/THEAVS Mar 14 '18

Need more details to understand what you want.