ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   time formats (https://www.excelbanter.com/excel-worksheet-functions/179877-time-formats.html)

adhide

time formats
 
when working out a time sheet for example, i want to be able to enter time
using a decimal point (.) instead of a colan(:) and be able to add them
together to get decimal hours.

ie. start 8.00 (8:00) finish 3.45 (15:45) = 7.75 (7:45)


All times are GMT +1. The time now is 08:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com