I need a simple formula that will do the following:
1. Take the time value in A1 (say 6:30 or whatever)
2. Multiply that by 1.5 (to get time and a half) and then
3. Round the sum to the nearest 15 minutes
All cells are formatted as [h]:mm
I can do these functions separately but can't figure out how to combine them into one formula.
Thanks,
Kirk
Bookmarks