See title says it all????.
Thanks : Garymore
See title says it all????.
Thanks : Garymore
Hi Gary and welcome to the Forum
Put a time in a cell or some cells. With those selected, right click and select Format Cells... With the Number tab displayed, under Categories list, click Custom. Then in the Type box (above the various formats) type hhmm and click OK. You'll get results like 0103 in your worksheet or use hh:mm for results like 01:03 (but the formula bar will still show the "normal" Excel time 01:03:00).
Use hh:mm"hrs" instead if you want the cell to appear as 01:03hrs (as it's sometimes spoken).
That's it and Excel will be able to do time calculations on the cell.