Question

Nana recently started a consulting business where he is paid based on the number of hours and minutes he works on client projects.

He needs a time tracking program, where he enters the date and the time he started working on a task, and then the date and time when he finished a particular task.

The program calculates the hours he spent on a task. It then calculates the amount of money Nana made tackling the task.

Note that: Nana is paid $5 dollars per hour.

If Nana works from 11AM to 1:30 PM on Monday 27th July, he would make 2.5 X 5 = $12.5 dollars.

Task

Write a program that would help Nana track his money.

The program calculates the hours he spent on a task.

It then calculates the amount of money Nana made tackling the task.

Time entered and information from the program should be stored in a csv or excel file for future referencing.

I need a very detailed python code for this ASAP. Thank you

Answer 1

import csv #to append in a csv file
def time_total_minutes(time): #converts a given time into total minutes, 11:00AM -> 11hrs -> 11*60 = 660 mins
minutes = 0 #stores the minutes to be returned
if time[-2:] == "PM" and int(time[:2]) < 12: #if the entered time is in between 1:00PM and 11:59PM
minutes += ((int(time[:2])+12)*60)
minutes += (int(time[3:5]))
elif time[-2:] == "AM" and int(time[:2]) == 12: #if entered time is in AM
minutes += (int(time[3:5]))
else:
minutes += (int(time[:2])*60)
minutes += (int(time[3:5]))
return minutes
  
  
while(True): #takes proper input for start_time according to the specification in print statements also checks for a valid time
start_time = input("Enter the start time: (hh:mm)(AM/PM)")
k = start_time #hh should be in between 0 and 12 and mm should be in between 0 and 59 last two values should be PM or AM and hh should be followed by ':'
if k[2] == ":" and k[-2:] in ["AM","PM"] and (int(k[:2]) >= 0 and int(k[:2]) <= 12) and (int(k[3:5]) >= 0 and int(k[3:5]) <= 59):
break #if valid then break
print("Retry!")
while(True): #takes proper input for end_time according to the specification in print statements also checks for a valid time
end_time = input("Enter the end time: (hh:mm)(AM/PM)")
k = end_time #hh should be in between 0 and 12 and mm should be in between 0 and 59 last two values should be PM or AM and hh should be followed by ':'
if k[2] == ":" and k[-2:] in ["AM","PM"] and (int(k[:2]) >= 0 and int(k[:2]) <= 12) and (int(k[3:5]) >= 0 and int(k[3:5]) <= 59):
break #if valid then break
print("Retry!")
while(True): #takes proper input for date according to the specification in print statements
date = input("Enter the date like dd/mm/yyyy")
d = int(date[:2]) #takes the date
m = int(date[3:5]) #takes the month
y = int(date[-4:]) #takes the year
if date[2] == '/' and date[5] == '/' and d >= 1 and d <= 31 and m >= 1 and m <= 12 and y >= 1990 and y <= 2050:
break #3rd and 6th values should be '/' and 1<=d<=31 and 1<=m<=12 and 1990<=y<=2050
print("Retry!")
start_mins = time_total_minutes(start_time) #converts into the total minutes
end_mins = time_total_minutes(end_time) #converts into the total minutes
if end_mins >= start_mins: #checs if end_mins >= start_mins
total_mins = end_mins - start_mins #gets the difference between the two times
h = (total_mins/60) #converts into total hours of work in float
total_money = h * 5 #finds the total dollars
print("Money: $"+str(total_money)) #prints
  
#to append in a csv file
list_ = [start_time,end_time,date,round(h,2),round(total_money,2)] #convert all the data into a list
myfile = open('money.csv','a') #open the desried file
wrtr = csv.writer(myfile, delimiter=',', quotechar='"') #creates a writer object to the file
wrtr.writerow(list_) #writes the list in the next row
myfile.flush() #flushes the contents of myfile
myfile.close() #closes the file
else:
print("End time is less that Start time of the day")