Thread: How to calculate hours based on certain criteria
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default How to calculate hours based on certain criteria
Hi,

Am Tue, 16 Aug 2016 17:08:17 -0700 (PDT) schrieb
:

I'm using a spreadsheet to keep track of my driving times, to make sure I get all the hours needed to get my license. All I have now is a column for START TIME, END TIME, NOTES, MINUTES, and TOTAL. I'm currently using the NOTES column to state whether or not the time is at night. The problem with that is I am not good at doing math with time, so I can't tell how many minutes of driving I have done at night.

for the minutes try:
=MOD(End Time-Start Time,1)*1440
If this not helps please post some examples with the expected output.


Regards
Claus B.
--
Windows10
Office 2016
Reply With QuoteReply With Quote