View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NoodNutt NoodNutt is offline
external usenet poster
 
Posts: 221
Default Converting time to decimal

Hi all

I can easily work the time calculation:
Start Time: Mon 00:01AM
Finish Time Mon 23:59PM

How do I calculate time past midnight into the next day so it = 11:00 hours.

Start Time: Mon 21:00PM
Finish Time: Tue 08:00AM


TIA
Mark.