Thread: How do i subtract a half hour from a time when 8 hrs.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Brown[_2_] Mike Brown[_2_] is offline
external usenet poster
  
Posts: 1
Default How do i subtract a half hour from a time when 8 hrs.
I did a timesheet in excel several years back and found the formula got
very messy to display hours and minutes since the computer thinks in
decimal and minutes are sexidecimal. I ended up needing an extra cell
to break up the hours and minutes (multiplying the partial hour by 60
to convert it to minutes).

I doubt I still have the template anywhere but I'll take a look.

Reply With QuoteReply With Quote