I am novice user in Macros. Could anyone help please?
The project is divided in following parts.
1) I got a excel file which have a data as per attached 1.jpg
2) I required a column which is going to use following formula which will calculate the total hours from timesheet
=IF((F1-D1)*24<0,(F1-D1+1)*24,((F1-D1)*24))
As per 2.jpg
3) Finally I only required 3 columns which will be employee no, the total hours which I received in step 2 and date which is in column 3. As per 3.jpg
Employee number, total hours worked and date (which is in DD/MM/YYYY)
The total hours worked are formatted to 2 digits.
Finally, After getting output as per 3.jpg. The file required to convert in .csv format and require to save on local drive
Thanks in advance.
Bookmarks