View Single Post
  #2  
Old 07-22-2007, 06:46 PM
mudraker's Avatar
mudraker mudraker is offline
Forum Moderator
 
Join Date: 10 Nov 2003
Location: Melbourne, Australia
Posts: 3,124
mudraker is a jewel in the rough
Suggest in F12 use =E12-D12 & format cell as h:mm
In E19 use custom formatting as [h]:mm this will display as 38:00
__________________
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely

Top Excel links for beginners to Experts

If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.