I'm working on a time sheet.
I have hours worked in decimal eg 7.5
I also have negative -7.5
How do I convert this into 7:30 and -7:30??
Many thanks
Emyr
I'm working on a time sheet.
I have hours worked in decimal eg 7.5
I also have negative -7.5
How do I convert this into 7:30 and -7:30??
Many thanks
Emyr
You can use negative times if you switch to the 1904 date system
Custom format result cell as hourPlease Login or Register to view this content.
Last edited by Ali Kırksekiz; 04-02-2015 at 10:26 AM.
Thanks
I've tried that and it works, some think that it may cause problem when sharing document with others?
Regards
Emyr
How about this?
=TRUNC(A1,0)&":"&TEXT((MOD(A1,1))*60,"00")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks