Ravi Sir's Cards › Excel
Co-working Space Management System in Excel (card 1 of 2)
Revision card 1 for Co-working Space Management System in Excel: Hours booked: =ROUND((E5-D5)*24,2) gives 2.0; Extra hours: =MAX(0,D5-E5) gives 0.0; GST: =ROUND(H5*Setup!$B$6,2) gives ₹5,760.00. Includes an example data table.
Read card text
What this card says
1 for Co-working Space Management System in Excel: Hours booked: =ROUND((E5-D5)*24,2) gives 2.0
Extra hours: =MAX(0,D5-E5) gives 0.0
GST: =ROUND(H5*Setup!$B$6,2) gives ₹5,760.00. Includes an
Example
data table
Learn this in the lesson: Co-working Space Management System in Excel: Plans, Members, Meeting Room Bookings, Monthly Billing and Dashboard