I'm having a difficult time formating a cell to show the time duration between two times.
So far, all I can get it to do is display in hours and minutes....I'd like it to display in just minutes.
Here's the example:
start end duration
7:30 AM 11:00 AM 3.30
I'd like the 3.30 to be displayed as 210 (180+30)
I can't figure out how to take the hours and / by 60 and them add the minutes.
Thanks.
Bruce
Bookmarks