Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › Microsoft Windows › How to Convert the time into the decimal point for the total hours?
jackyleunght2002

406 posts

Ultimate Geek
+1 received by user: 26


#296412 15-Jun-2022 13:22
Send private message

Hello there.

 

 

 

Just want to know, i am on excel at the moment. 

 

let say a worker is working Start on Column A1 09.00- Finishing Time B1 18.00 and minus the break C1 0.30 is 8.5 hours

 

so on the D1, how should I program the excel sheet to show 8.5 hours on the excel sheet. 

 

thank you very much

 

 

 

Jacky 

 

 

Create new topic

This is a filtered page: currently showing replies marked as answers. Click here to see full discussion.

Behodar
11100 posts

Uber Geek
+1 received by user: 6083

Trusted
Lifetime subscriber

  #2927949 15-Jun-2022 14:16
Send private message

That seems a little complex. In D1, just put =(B1-A1-C1)*24 and format as a number. That seems to give the required result (8.5).

 

The *24 is because formatting a time as a number will usually report it in decimal days. Since we want decimal hours, we multiply by 24. Hopefully nobody works across the daylight saving changeover :)

Create new topic








Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.








RSS feeds
Main feed
Forums feed
Copyright
©2002-2026 Geekzone®
Site features
Geekzone BI dashboard
Geekzone Badges
Geekzone Status Page

 

Site Information
Subscribe to Geekzone
Privacy Statement
Forum Usage Guidelines (FUG)
Advertising
Trademark and copyright