Forum Discussion
CALCULATING 24 HOUR TIME TO THE NEAREST QUARTER HOUR
I bill clients and pay contractors to the nearest quarter hour. I cannot seem to put together a formula that will do the job. say start time is 0800 hrs stop time 1215 hrs. the formula (B-A)/100 ...
You are close. The answer would be =(B-A)*24. The B-A returns 4:15, but if you format it as a decimal (not time) it becomes 0.17708.... depending on how many digits you display. In Excel going from 0 to 1 in "time" is the same from going from midnight one day, to midnight the next day. What you need to do is convert from 0...1 to 0...24. Multiplying by 24 does that.