Hey All,
i want to be able to add 0:12 as 12 minutes in Excel
if i format it to [h]:mm it LOOKS ok but in the formula bar it shows as 12:12 AM
problem with this then is that it won't pick up through excel due to this difference.
anyone know how to fix?
if it's easier i just need to check if the time is under 15minutes if it's quicker VBA could would be great
i want to be able to add 0:12 as 12 minutes in Excel
if i format it to [h]:mm it LOOKS ok but in the formula bar it shows as 12:12 AM
problem with this then is that it won't pick up through excel due to this difference.
anyone know how to fix?
if it's easier i just need to check if the time is under 15minutes if it's quicker VBA could would be great