I have a sheet set up that calculates time worked by 15 minute increments. I want to find out a total charge if each 15 minutes is $25. How is this achieved?
Hi Scott,
It's always best to supply your workbook so we don't have to recreate it.
Times and dates are stored as serial numbers in Excel
https://www.myonlinetraininghub.com/excel-date-and-time
https://www.myonlinetraininghub.com/excel-time-calculation-tricks
So 15 minutes is stored as (1/(24*60))*15 = 0.01041666666 recurring.
1h 45m is 0.072916666 recurring.
Divide one by the other to get 7.
If Total Time is in C13 then Total Amount =25*C13/((1/(24*60))*15)
Regards
Phil
I actually saw that you had C13 in the formula and it was in the G13 cell. I changed that in the formula and it worked perfectly!! I thank you so much!!
no worries 🙂
