Trying to SUM working hours after midnight
I have this formula:
=ROUNDDOWN(((B1-A1)*24) ; 1)
which calculates the duration between two times (B1=end time, A1=start time) and then converts it to decimal.
The current problem I have with this formula is that it is unable to give a correct answer when the end time is past midnight.
How can I improve the formula to make it work when the end time is past midnight?
Solution
Please try the following for a list of dates
=INDEX(ROUNDDOWN(((B2:B6-A2:A6+(B2:B6<A2:A6))*24) ; 1))
(Do adjust the formula according to your ranges and locale)
- Automatically Delete Files from Google Drive Older than 3 Days
- Format JavaScript date as yyyy-mm-dd
- Get a list of dates between two dates
- Convert String to Calendar Object in Java
- Completely illogical Date() values, in Swift
- Quick Measure Error: "Only Power BI-provided date hierarchies are supported"
- Parsing date in Pascal
- Library to calculate date in Javascript
- How to add minutes to current time in swift
- Python Pandas: update last dates values of parameters with simple dynamics grouped by id
- Java Date vs Calendar
- how to sort a sequence of numbers treating them as a date but without zeros
- Whats the point of Locale in DateTimeFormatter?
- Different between two date, result in years and days not month in php
- Get mySQL MONTH() to use leading zeros?
- What is this date format? 2011-08-12T20:17:46.384Z
- Iterating through a range of dates in Python
- How to subtract two java.sql.Date dates?
- How to add months to a date in JavaScript?
- Displaying the build date
- How to correctly join two tables that each have Start Date and Stop Date columns?
- Why does Date() and Calendar.current.startOfDay(for: Date()) produce different days?
- Converting Excel Date Serial Number to Date using Javascript
- Convert date to datetime in Python
- Format date as dd/MM/yyyy using pipes
- Converting Date to epoch milliseconds
- HIVE SQL script to set end date to 12-31 of current year
- Is there a way to count number of ISO weeks in a given year using Moment.js?
- How can I modify this script to select any folders dated in the last 12 months?
- Find first Monday of given month or last Monday of previous month