Hey,

I tried to switch the time so that I can enter the start time as 8:30 as oppose to 8.5 (on advice from my coworkers). How would I do this with regards to the formulas?

I dont seem to be getting it to work as the format it comes in is very rigid in the sense that it comes in the format hh:mm AM/PM (all in one cell). where I would want them to enter just the number in one cell and AM/PM in the other without conflicting

thanks in advance